You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit. While not a difficult task, the question of how to manipulate SSIS package ...

Rolling a script to perform the FTP functions will allow you more flexibility than the built-in task and more productivity. In my last post, I talked about setting up and using FTP in an SSIS package.

The scripting engine has now, in SSIS 2008, been re-written to support Visual Studio Tools for Applications (VSTA). This allows easier referencing of all .NET assemblies and therefore more flexibility ...