Discussion:
move DTS package from SQL Server 2000 to 2005
(too old to reply)
Srikanth via SQLMonster.com
2009-02-14 04:17:55 UTC
Permalink
Hi All,

This is verrrrrrrrrrry urgent. It will be very helpful if some one
reply me ASAP.

We have a SQL Server 2000 server with a database of 35GB which has so many
DTS packages. NOw we need to copy this database from this server to the 2005
server. We are done with copying the datbase and all the users associated
with it, but there are around 75 DTS packages associated with this and we are
unable to move them to SQL Server 2005.I tried with storing the DTS in
structure related file and then tried to copy those files in 2005 server
which is regular but i am getting an error while doing this. So any help
related to this will be very helpful.

Thanks in Advance,
Srikanth
--
Srikanth

Message posted via http://www.sqlmonster.com
tbradshaw via SQLMonster.com
2009-02-15 03:30:47 UTC
Permalink
Srikanth,

Would this article help you?

http://www.sqldts.com/204.aspx

Best Regards,
Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200902/1
Continue reading on narkive:
Search results for 'move DTS package from SQL Server 2000 to 2005' (Questions and Answers)
4
replies
Converting Access website to MySQL?
started 2006-04-20 06:48:22 UTC
programming & design
Loading...