Hi Greg,
I read your comment and I would like to try it...
" create a new DTS package in SSMS by opening an existing legacy DTS package and saving it with a new name. Then, open the new package and replace what's in it with whatever you want in the new package."
We have an existing DTS package in SQLPRODUCTION , I would like copy and modify it to SQLTEST using SQL Server Management Studio. I downloaded Design-time Support for SQL Server 2000 DTS Packages.
I'm new in SQL Server 2005, can you tell me the steps on how to do this?
Thanks,
M