DTS Script?

• bshaw

  Right there with Babe

  Points: 750

  More actions

  May 13, 2005 at 1:05 pm

  #163581

  My company is preparing to migrate our SQL Server 7 from NT to Windows Server 2003. So among other things, I've been looking for a way to script all of my many DTS packages, then have the ability to change the server name, and the UNC for the output files (Excel, text, etc.). Any help would be appreciated.

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 13, 2005 at 1:19 pm

  #558834

  First I would backup msdb as all the packages are saved there.

  2nd you could use sqldmo to save all you dts to file just in case you can't transfer msdb nor restore it.