Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 28, 1999

DTS How to... Obtain a List of DTS Packages

By Darren Green

1 How to Obtain a List of DTS Packages

A common request is how to obtain a list of DTS Packages, to populate a list box for example. The easiest way is to just query the system tables of the msdb database:

/* List Server Packages */
SELECT DISTINCT name FROM sysdtspackages
/* List Repository Packages */
SELECT DISTINCT Name, PackageID 
FROM TfmPackage INNER JOIN RTblNamedObj 
 ON tfmpackage.IntID = RTblNamedObj.IntID

N.B. The PackageID is very important for repository packages, as it is required to identify and load the package. Server packages can be loaded just using the name.

An alternative is to use SQL-NS. For an example of this see the sample:
  x:\mssql7\devtools\samples\sqlns\vb\browse\

There is also a relevant Microsoft Knowledge Base Article:

  • Article ID: Q241249
  • INF: How to Obtain a List of DTS Packages
  • http://support.microsoft.com/support/kb/articles/Q241/2/49.asp



  • MS SQL Archives

    Comment and Contribute

     


    (Maximum characters: 1200). You have characters left.

     

     




    Latest Forum Threads
    MS SQL Forum
    Topic By Replies Updated
    SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
    Need help changing table contents nkawtg 1 August 17th, 03:02 AM
    SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
    SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















    Thanks for your registration, follow us on our social networks to keep up-to-date