Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Execute a DTS package from a stored procedure 2
- Thread starter RobS23
- Start date
-
2
- #2
rajeevnandanmishra
Programmer
Hi RobS23,
Try to as following:
If you had saved DTS to file
EXEC master..xp_cmdshell "dtsrun /FmyFile /NmyPackage /MmyDtsPassword",no_output
If you saved it on server msdb
EXEC master..xp_cmdshell "dtsrun /NmyPackage /MmyDtsPassword",no_output
If you saved it in Meta Data
EXEC master..xp_cmdshell "dtsrun /NmyPackage /MmyDtsPassword /RmyRepositoryName",no_output
Try to as following:
If you had saved DTS to file
EXEC master..xp_cmdshell "dtsrun /FmyFile /NmyPackage /MmyDtsPassword",no_output
If you saved it on server msdb
EXEC master..xp_cmdshell "dtsrun /NmyPackage /MmyDtsPassword",no_output
If you saved it in Meta Data
EXEC master..xp_cmdshell "dtsrun /NmyPackage /MmyDtsPassword /RmyRepositoryName",no_output
- Status
Similar threads
- Locked
- Question
- Locked
- Question
