DTSRun and DTSExec

DTSRun and DTSExec

Just a quick note about differences about SQL DTS.
SQL2000 use DTSRun and DTSRunUI.
SQL2005 use DTSRun and DTSRunUI for legacy package or DTSExec and DTSExecUI for new DTS managed by SSIS.
You can find legacy package query sysdtspackages table within MSDB.

I will to use DTSExec in a small project,I will write about this then