SQL 2000 DTS to SQL 2005 SSIS -
09-05-2006
, 02:05 PM
I have a new SQL 2005 Server. I have restored a back up of a SQL 2000
production database to the 2005 instance.
I have several 2000 DTS packages that run as schedule jobs where the SQL
Agent is run by a domain account. This same domain accout run ths SQL Agent
on the 2005 box.
What are the recomended steps to move these Server DTS packages from 2000 to
2005 and have able to be scheduled to be run?
Thanks in advance. |