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
  2. dineshasanka Moderator

    These informations are built into DTS package. I don't think it is saved inside tables
  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.
  4. satya Moderator

Share This Page