exporting multiple dts packages...

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  September 6, 2005 at 5:02 am

  #109911

  Hi,

  does any clever clogs know how to export 20 dts packages to .dts files from a command line?

  Its a pain saving each one individually.

  Any help welcome

  Eamon

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  September 6, 2005 at 6:40 am

  #587755

  Here's a link to an article that you might want to take a look at.

  http://www.sqldts.com/default.aspx?204

  Although with there only being 20 i'd probably just do it manually if it were me

  Mike

• philcart

  SSC-Forever

  Points: 47795

  More actions

  September 6, 2005 at 5:13 pm

  #587959

  Use the DTSBackup2000 tool available at http://www.sqldts.com/default.aspx?242

  It has a command-line and GUI interface.

   

  --------------------
  Colt 45 - the original point and click interface