Post reply

DTS logins

  • October 8, 2003 at 12:48 pm

    #59378

    Hi,

    Does anyone know how to get list of DTS packages on a SQL server along with login information.

    Thank You

    yama

  • October 8, 2003 at 1:17 pm

    #477621

    What login information do you look for?

    Check sysdtspackages table in MSDB.

  • October 8, 2003 at 1:30 pm

    #477623

    I want to know all logins used for servers which are there in the DTS.

    checked sysdtspackages...doesn't help much.

  • October 8, 2003 at 6:05 pm

    #477654

    The package is stored in sysdtspackages as a binary object. What you'll need to do is,

    a) manually open each package and check the required properties. (got some time to waste haven't you ?)

    b) use vbscript to open each package and read the properties for you. Have a look the script I posted here,http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16191&FORUM_ID=19&CAT_ID=3

    This will give you an idea on how to reference the properties needed. All you'll need to do is wrap this script in a loop that iterates through each package on the server.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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