By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,364 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,364 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Dec 31 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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...FromCSharp.asp

Regards,

Plamen Ratchev
http://www.SQLStudio.com
"Fir5tSight" <fi********@yahoo.comwrote in message
news:11*********************@73g2000cwn.googlegrou ps.com...
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

Dec 31 '06 #2

P: n/a
Hi Plamen,

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

-Emily

Jan 2 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.