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.

Tags: ,

About author

Vittorio Pavesi