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.

PowerShell scripts reduce the effort in running repetitive tasks. If you frequently execute scripts at pre-defined times or specified time intervals, you may want an efficient way of not having to ...