SQL Server Performance

DTS packages Source connection information

Discussion in 'SQL Server 2005 Integration Services' started by ashish.johri, Oct 9, 2007.

  1. ashish.johri New Member

    Is there any table where we have source connection and destination connection information about the DTS packages?
    None of these tables in the msdb have this information.
    1) sysdtscategories
    2) sysdtspackages
    3) sysdtspackagelog
    4) sysdtssteplog
    5) sysdtstasklog
    6) sysdtspackages90
    7) sysdtspackagefolders90
    8) sysdtslog90
    ashish.johri, Oct 9, 2007
    #2

  2. dineshasanka Moderator

    These informations are built into DTS package. I don't think it is saved inside tables
    dineshasanka, Oct 9, 2007
    #3

  3. martins New Member

    Dinesh is right, you wont find it in any system table. We use udl files in all our DTS packages, which helps a lot in terms of source control and implementing changes to connections.
    martins, Oct 10, 2007
    #4

  4. satya Moderator

    satya, Oct 10, 2007
    #5

Share This Page