Can you call/run a DTS package from a batch file? I want to have errors fire a DTS package that emails me and loads a few database items along with a table copy.<BR><BR>Mickey
Yes, lookup the command dtsrun
DTS is separate from SQL Server and can be run from a command line as far as I am aware... however there may be login issues to be resolved in this.<BR>So in short the answer is YES it in theory is possible.. Check out SQL Server Books Online
Thanks a ton!