DTS deployment

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  February 3, 2010 at 7:52 am

  #96888

  [font="Verdana"]Hi All,

  I have more than 35 DTS packages which needs to be deploy on one of the new server. Can anybody tell me is there a way, so that I can deploy such packages from source server to destination server in a single run?

  What I found is, Save As all packages on source server in SQL Server so that I can develop a new package to transfer these packages from source's msdb..sysdtspackages table to destination's msdb..sysdtspackages.

  I haven't tried it yet, can anybody explain, is this a way to deploye bulk DTS packages from one server to another server in a single run?

  Thanks in advance,

  Mahesh[/font]

  MH-09-AM-8694

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  February 3, 2010 at 9:17 am

  #1113001

  I've done that, but I've come to prefer this tool: http://www.sqldts.com/242.aspx. It's way easier to use and is dead dependable...and it's free.

  Greg