Friday, March 9, 2012

Run DTS package in sql server 2005

We are about to migrate a 2000 server to a different server with 2005. One of the dts packages has been giving us problems converting it, so we want to leave it as a dts for now so we can look at it later but still upgrade now. Since I'm moving the database to a new server I need to know how to set up a job to run the dts, as well as how to ensure the dts is moved to the new server as well.

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