Technical: Microsoft – SQL Server – Document DTS Packages

Technical: Microsoft – SQL Server – Document DTS Packages


Prior to version 2005, MS SQL Server mainline ETL building block was DTS (Data Transformation Services.

Starting from v2005, DTS was replaced with SSIS (SQL Server Integration Services).


Thankfully, legacy DTS Packages are still supported in v2005 through v2008/R2.

MS SQL Server v2005+, View MSDB – DTS Packages

In SQL Server Management Studio, to view the DTS Packages please do the following:

  • Launch Microsoft SQL Server Management Studio
  • Connect to the SQL Server Instance
  • Access the SQL Node
  • Transverse the SQL Node’s — Management,  Legacy, Data Transformation Services

Document DTS Packages

Using Transact SQL, list DTS Packages

use [msdb];

select as packageName
	, tblDTSPackage.[description] as packageDescription
	, tblDTSPackage.createdate		  
	, tblDTSPackage.[owner] as packageOwner
	, as dtsCategory		
	, tblDTSCategory.description as dtsCategory

from   msdb.dbo.sysdtspackages tblDTSPackage

	  left outer join msdb.dbo.sysdtscategories as tblDTSCategory

		on tblDTSPackage.categoryid =

where  tblDTSPackage.createdate =
			select max(tblDTSPackage_Inner.createdate)
			from   sysdtspackages tblDTSPackage_Inner					where =
order by	

Additional Software

If you are running Microsoft SQL Server Management Studio v2005, you might need additional software as documented in “Integration Services download” ( )

  • Microsoft SQL Server 2000 DTS Designer Components
  • Microsoft SQL Server 2005 Backward Compatibility Components


Ongoing Support

Starting from MS SQL Server v2012, Microsoft no longer supports the DTS run-time.

Discontinued Integration Services Functionality in SQL Server 2012

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s