Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
File Handling in SSIS
You could try two 'For Each Loop Container' each handling a different file type and its relevant piece of code.- Viass
- Post #2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Create a connection to Oracle 10g on 64bit windows
'But i have not been able to connect to an oldeb source component using the oracle connection manager'.. Have you got any error message?- Viass
- Post #5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Create a connection to Oracle 10g on 64bit windows
To connect to Oracle, first you need create a connection using the 'Microsoft OLE DB Provider for Oracle'. You will then be asked the Oracle Servername, Username and Password. Once the connection is established, you will be able to access the Oracle tables using the 'OLE DB Source'Task. Hope...- Viass
- Post #2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Migrating DTS package to SSIS
To execute your SSIS package in 32-bit mode on a 64-bit OS you need to run your package using DTEXEC or its GUI-counterpart,DTEXECUI.exe. The 32-bit version of dtexec.exe is located at Program Files(x86)\Microsoft SQL Server\90\DTS\BINN\dtexec.exe. Invoke dtexec.exe within a batch file or...- Viass
- Post #2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Read A Table Row Into A Variable
1. create a variable >Define a variable 'var1' >Datatype as 'object' >Value as 'System.Object' 2. Right Click Execute SQL Task and choose EDIT General TAB SQLSourceType : Direct input SQLStatement : Select 'column1' from 'Table1' Result Set TAB >set 'Result Name' to 0 >set 'Variable...- Viass
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
