News

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit.
How to create a script task that uses the SSIS PDW destination adapter The Integration Services Script Task allows you to perform virtually any operation that can be accomplished in a .Net application ...
The Script task can raise events by calling methods on the xref:Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel.Events%2A property of the Dts object. For more information about how ...
This relatively simple example demonstrates how you can call AX business logic from SSIS by connecting to a custom web service. It assumes some knowledge of the individual technologies themselves. The ...
If you need to be a little more advanced with your FTP you can write a Script Task that utilizes FTP objects. As luck would have it, setting up FTP in an SSIS script will be the topic of ...
The scripting engine has now, in SSIS 2008, been re-written to support Visual Studio Tools for Applications (VSTA).