Can I execute a DTS package from T-SQL?
Database
2
Posts
2
Posters
0
Views
1
Watching
-
It'd really make this project simple if i could, but this part doesn't appear to be as easy I thought.
You could use a combination of xp_cmdshell extended stored procedure and the dtsrun utility. Look in the BOL for the dtsrun utility, it's a command line program to execute DTS packages. Jeff Martin Triple20 Software