In your SSIS packages, if you need to read from or write to Oracle likely that you most probably hit some Oracle Client related configuration issues. ORACLE_HOME, PATH environmental variables etc. Sometimes you may see a machine needs to run SSIS packages and you see that an Oracle Client is installed but you don’t know […]

Read More → SSIS: How to know if the installed Oracle Client is 32bit or 64bit on your SSIS machine

  It has been reported by one of our customers that they have developed an SSIS package which needs to connect to an FTP Server on their internal network to download some files and take some data from the files to put it into some destination like a SQL Server table after doing some conversions/calculations […]

Read More → Why my FTP Connection Manager is not connecting to my FTP Server inside SQL Server 2005/2008 Integration Services Package ?