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

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...r-dts/200902/1