Post reply

How to get the details about dts package objects using Query Analyzer?

  • May 30, 2006 at 7:31 am

    #153006

    Hi DTS Experts,

    Is it possible to get the details about DTS Objects(DTS Tasks/DTS connection present in the DTS package) by providing the dts package name using Query Analyzer.

    The reason behind this requirement  I need to know the dts packages that has particular DTS Task (say Dynamic Properties Task) with it. To get the above requirement I have to manually open each DTS Package in the EM and check for particular task.

    Any/all sql queries to get the details about dts is most welcome

     

    Hope everyone got the picture.

    Thanks in Advance

    Regards

    Marimuthu

  • May 30, 2006 at 10:00 am

    #640729

    DTS packages are stored in binary in msdb tables so you can't search them with T-SQL.  What you can do is save the packages as files and search them.  There's a script posted in the script section that will copy all packages in an instance to text files.  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1613

    Greg

    Greg

  • June 1, 2006 at 8:04 am

    #641185

    Thanks a lot Greg Charles

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

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