SQL Server Performance

how to get DTS information?

Discussion in 'SQL Server DTS-Related Questions' started by newchina, Sep 6, 2006.

  1. newchina New Member

    Hi All
    if anyone knows how to get the DTS package information, like connection string, password etc, without opening the DTS package in Design screen? the DTS packages stored in SQL Server 2000.

    thanks in advance for your great assistance.

    --Long
    newchina, Sep 6, 2006
    #2

  2. eramgarden New Member

    maybe turn on profiler and see what goes on behind the scenes
    eramgarden, Sep 6, 2006
    #2

  3. Luis Martin Moderator

    No way, with profiler (like eramgarden said) you have some information but not all what you want.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Sep 6, 2006
    #2

  4. sunsanvin New Member

    sunsanvin, Sep 6, 2006
    #2

  5. satya Moderator

    satya, Sep 7, 2006
    #2

  6. newchina New Member

    thanks for all the good reference. i wished i could get connection info from certain system tables.

    --Long
    newchina, Sep 7, 2006
    #2

Share This Page