Script Or Store procedure

• kaushik.rengarajan

  SSC Journeyman

  Points: 78

  More actions

  March 4, 2009 at 2:34 am

  #95103

  Dear All,

  There is about 400 Dts packages available in my DataBase, i need a Sp or Script or any method to find a particuar String from all DTS Packages, can any one help me regarding this Issue.

  Thanking in Advance.

  Kaushik

• vinurajr

  SSCrazy

  Points: 2404

  More actions

  March 4, 2009 at 4:56 am

  #953005

  what is the requirement to find the string from a package..?...

  if u want to find the dts names there are system tables that are there in the MSDB Data Base.

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  March 4, 2009 at 6:21 am

  #953075

  Here is an article and a vb script that scripts the properties of all tasks in a text file. You can easily modify it by doing a search on the properties and send only the package names to the file.

  --Ramesh
  

  ---