How do I get a DTS package back into a database?

• kwitzell

  SSCrazy

  Points: 2470

  More actions

  March 30, 2005 at 7:37 am

  #164151

  Prior to moving databases from one server to another we saved a DTS package as a .BAS file. Now I need to reinsert this DTS package back into the database. Since the package was not saved as a structured storage file I cannot use (as far as I know) the standard tools supplied with SQL Server. Is there any other way to reinsert this package? Any and all help will be greatly appreciated! Thanks!

  Ken

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  March 30, 2005 at 8:56 am

  #549570

  See this link.

   

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_8jfp.asp

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!

• kwitzell

  SSCrazy

  Points: 2470

  More actions

  March 30, 2005 at 1:22 pm

  #549643

  Thanks Jonathan, that did the trick!

  Ken