DTSRun to DTSExec

• Jake Shelton

  Hall of Fame

  Points: 3109

  More actions

  March 26, 2014 at 9:57 am

  #291538

  Hi all,

  We are migrating SQL 2K db's to a new box and to SS2K8.

  We've got nearly a hundred sprocs and scheduled jobs which currently reference DTS packages. I understand that DTSRun is used to call SSIS packages, which we are building using the same names as on the old server.

  Would be grateful for any advice on how to upgrade these objects , preferably without manually opening each and pasting the DTSExec command!!

  Cheers,

  Jake.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 26, 2014 at 11:01 am

  #1700402

  I don't think there is any alternative method. Just search and replace.

  --

  SQLBuddy