DTS Export

• cocpl-646717

  SSC Journeyman

  Points: 93

  More actions

  February 19, 2008 at 7:49 am

  #184097

  Hello,

  I want to Export all my DTS (SQL-Server 2000, stored in msdb) in one File because I have to know which user is used to connect to Database.

  Which Options have I?

  Is it possible to modify the user and password without open all DTS separatly?

  Can I modify the user about a query? I can´t read the value of msdb.dbo.sysdtspackages.packagedata.

  Thank you for help me and excuse my bad english 😉

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  February 20, 2008 at 12:05 pm

  #780341

  Two options that I've used. The first is from the script section here at ssc: http://www.sqlservercentral.com/scripts/Miscellaneous/31613/. The second is a free tool from SQLDTS.com: http://www.sqldts.com/242.aspx.

  Greg