Post reply

Is it possible to get the package name,server name,username etc in dts package using tsql script

  • August 11, 2011 at 7:07 am

    #100775

    Hi ,

    We have around 450 dts packages. I need to findout what are all dts packages were connected in

    scs database. I cannot open each and every dts packages and see the connections. Instead of that

    Is there any way to get the below details using tsql script.

    Example :

    dtspackagename, servername,databasename,username etc..

    I would appreciate, if anybody share the script.

    Thanks in advance.

    Balaji G

  • August 11, 2011 at 8:33 am

    #1367327

    I would say no, using TSQL you could NOT get that data. It is contained within the contents of the package.

    You could probably do it by using the DTS object model that would load each package and then walk through the package and spit out the information. I would probably do it in .NET.

    And I would say my answer would be the same for SSIS as well.

    you also might do a google search for a tool.

    CEWII

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

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