my initial thought is just to export the dts then import it to the new server. After that set up a new job on the new server to run the dts. I cant figure out how to set up the job though. I guess I need to write a dtsrun command, but I've always done that by right clicking on the dts and having the wizard create the command for me. And it seems with 2005 i can't do that even with the backward compantability tools installed. Anyone can help?
Yes the legacy DTS packages still works and you can still use them with SQL Server 2005 / Calling them inside a JOB using DTSRUN. Install SQL Server 2005 DTS Designer Components
for legacy support and continue working with legacy 2000 DTS packages
HTH
Vishal
No comments:
Post a Comment