I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server?
+1
A:
you should connect to integration services... and then in the MSDB folder or in the FileSystem folder, it depends how did you save them
Ironicnet
2009-01-14 16:01:48
i used the import/export wizard and saved them on the server in the last step. i've tried saving them to the filesystem, but was not able to edit them that way either.
Sheehan Alam
2009-01-14 16:06:58
using the Business Intelligence Studio I was able to save them in the MSDB folder. I don't think there is a way to save them using the Import/Export Wizard in SQL Management Studio.
Sheehan Alam
2009-01-17 20:24:47
From the SQL Management Studio, you can connect to a SSIS server. When connected to a Integration Services server, you can run, import or delete packages.If in the import/export you save the package to the MSDB, you will see it. I think that the FileSystem option is bugged or not working maybe.
Ironicnet
2009-01-20 12:15:43
+1
A:
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.
Cheers, Andy.
Andy Jones
2009-02-06 11:39:52