Post reply

Script Or Store procedure

  • 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

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply