call DTS stored procedure in asp.net

[OhioSteve]

I want to create an aspx page with a button. When the user presses the button, I want a dts stored procedure on SQL Server to fire.

Can you get me started on the syntax for that?

 

[OhioSteve]

Oops! I made a big error when I typed my question. I really want help with a button that triggers a dts package. Triggering a stored procedure would be easy.

 

[tperri]

This will get you started, I hope

http://support.microsoft.com/?id=319985

 

[ca8msm]

You may also want to look at the Microsoft.SqlServer.Dts.Runtime namespace:

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.