How to add DTS (Data Transformation Services) object to .NET project

[Fir5tSight]

Hi,

I have a C#.NET project (in a Visual Studio environment). In the
project, I have a dialog to let the user enter some values to be used
as parameters for a DTS package. The idea is that when the user enters
required values and selects the button, "Run DTS Package", the DTS
package should be launched.

Does .NET have any utility for adding / running a DTS package in the
C#.NET project?

Thanks!

-Emily

 

[Plamen Ratchev]

Here are two examples for running DTS packages with C#:

For SQL Server 7.0 and SQL Server 2000:
http://www.sqldev.net/dts/ExecutePackage.htm

For SQL Server 2005:
http://www.codeproject.com/useritems/CallSSISFromCSharp.asp

Regards,

Plamen Ratchev
http://www.SQLStudio.com

 

[Fir5tSight]

Hi Plamen,

Thanks for the links! The C# sample code is really helpful.

-Emily