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.

Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 comments: