Running DTS packages in C#

[TheBigJ]

Does anyone know of any good websites/resources that could help me
figure out how to alter a DTS package's Transform Data Task's
properties (specifically changing the destination table) using c#.
Thanks

[Jason Cumberland]

I put a C# class together to do this that you can call from whatever.  It makes a new package with one data pump instead of altering an existing one, but it could be changed pretty easily.  I've attached the source, but here's a link.  http://qcumberland.com/download/DynamicDataFlow.cs

If you want to call this from a script task you will need to put the file in the %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727directory as well as add it to the GAC.


Here are some of the resources I used to put it together, but searching for the object names pretty much does the trick:

http://msdn2.microsoft.com/en-us/library/ms345164(SQL.90).aspx
http://blogs.conchango.com/jamiethomson/archive/2005/02/28/1085.aspx
http://lakshmik.blogspot.com/2005/05/how-to-programmatically-create-ssis.html
http://www.dbtalk.net/microsoft-public-sqlserver-dts/ssis-object-model-programatically-script-288494.html
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=108043&SiteID=1

:wq

[TheBigJ]

Thanks so much! I will try that and let you know!!