How to work with multiple files in FTP Task

Posted by on Nov 11, 2009 in SSIS | No Comments

FTP Task is one of SSIS tasks for File Upload,Download or manage ftp file and folders, FTP Task Configuration is easy and all things that must be done is that create a FTP Connection Manager and then set File Transfer configurations. But problem is when you must do this with more than one file, Answer ...

Read More

Dynamic connection string in SSIS

Posted by on Oct 25, 2009 in SSIS | No Comments

This is a common problem: Use a dtsx package with dynamic database connection. In fact there are times that you need to set connection string of database from outside of package. solution: Suppose that you have an OLE DB connection and set it to same database which you want to work with and named it ...

Read More