Can you call a DTS in MSSQL programitcally?

[darrel]

I have a DTS set up in MS SQL. Can that be called programatically from an
aspx page?

I could just rewrite the DTS so that all the functionality is directly in
the ASPX page, but since it's already written as a DTS, I thought I'd first
check to see if I can do that programatically...

-Darrel

 

[Scott Allen]

Yes, there are a few samples around (see
http://sqldev.net/dts/ExecutePackage.htm for one).