dbTalk Databases Forums  

SQL 2000 DTS to SQL 2005 SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL 2000 DTS to SQL 2005 SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
brusk002
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.