Deployment of DTS

• binu.m.a

  SSC Enthusiast

  Points: 127

  More actions

  November 6, 2007 at 2:31 am

  #70390

  I have a DTS file xxx.dts.I have to deploy this file to a different SQLSERVER.Pls help me.

  Binu

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 6, 2007 at 9:20 am

  #748739

  Open the package file in DTS Designer, click Package -> Save As and save to the SQL Server instance where you want the package.

  Greg

  Greg