Copy stage between sql2000 and sql2005

Copy stage between sql2000 and sql2005

Post by U2hlcm1hbi » Tue, 12 Dec 2006 02:35:01


We have dts package that is deployed on a sql 2000 server. We now have a need
to use a copy stage to move objects from the sql 2000 server to a sql 2005
server. In the 2000 management console, it won't let me connect to the 2005
server. What is the recommended way to interopt with sql 2000 and 2005 with
regards to using dts to move objects between the two versions of sql server
when the package needs to reside on the sql 2000 server??
--
Ken S