adibjafari
SSC Enthusiast
Points: 126
More actions
October 19, 2004 at 6:03 am
#65696
I want to allow users (running an application) to be able to run certain dts packages, how can I do this?
Regards
Adib
Steve Jones - SSC Editor
SSC Guru
Points: 736078
October 19, 2004 at 12:17 pm
#527232
dtsrun will execute procedures. You will need to redistribute some DLLs for this.
Jean-Pierre PONS
SSC-Addicted
Points: 497
October 19, 2004 at 10:34 pm
#527267
You can run it with a command line statement :
dtsrun /Sserver /Uuser /Ppassword /Ndts_package_name
correctly encapsulated to give corrects parameters.
jfb
SSCrazy
Points: 2469
October 20, 2004 at 7:46 am
#527313
Hi,
You can use .Net to execute you dts.
http://www.sqldev.net/dts/DotNETCookBook.htm
Regards,
JFB
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply