How to import a DTS package from one computer to another computer database

• Sql Student-446896

  Default port

  Points: 1425

  More actions

  October 30, 2008 at 4:53 pm

  #195394

  Hi,

  I have a DTS packge that does some updates everyday to the production database. I need to change something in the package and i want to work on my laptop with a local database installed. I saved the package as a .DTS file in my production computer. Copied it in my jump drive.

  How can i import this .dts file into the database in my laptop?

• Anam Verma

  SSCertifiable

  Points: 5365

  More actions

  October 30, 2008 at 5:12 pm

  #892121

  check this

  http://sql-server-performance.com/Community/forums/p/19021/107749.aspx

  using a script

  http://www.nigelrivett.net/DTS/s_LoadPackageToServer.html

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  October 30, 2008 at 5:46 pm

  #892125

  Right Click on "Data Transformation Services", Click on "Open Package" and select .dts file.

  [font="Verdana"]--www.sqlvillage.com[/size][/font]