Srikanth via SQLMonster.com
2009-02-14 04:17:55 UTC
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
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
Message posted via http://www.sqlmonster.com