Where does SQL Server store the DTS packages?

Question

I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server?

Solution 1

you should connect to integration services... and then in the MSDB folder or in the FileSystem folder, it depends how did you save them

Solution 2

As you probably know, DTS was deprecated and was replaced by SSIS in SQL Server 2005. It IS possible to edit and run DTS packages in SQL Server 2005 however, by installing the “Feature Pack for Microsoft SQL Server 2005”. Particular components that you should look at are “Microsoft SQL Server 2000 DTS Designer Components” for editing and “Microsoft SQL Server 2005 Backward Compatibility Components” for the runtime.

This allows you to upgrade from SQL Server 2000 to SQL Server 2005 and your old DTS packages will still run. This leaves you time to upgrade them to SSIS.