• 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