SQL 97 DTS to SQL 2000

vinnie · September 12th, 2004, 11:42 AM

Need help if anyone knows how to import or what method works to copy my current SQL DTS to new SQL 2000 server, note 2 different PC,s on same network.

Anyone out there done this, knows how?

Help would be greatly appreciated.
[email protected]

happygv · September 13th, 2004, 05:39 AM

Hi Vinnie,

Here you go... DTSBackup 2000 - Install this you can backup all your DTS packages from one server and restore it on the other.

Also take a look at this - Transferring DTS Packages

Cheers!

_________________________
- Vijay G
Strive for Perfection

vinnie · September 13th, 2004, 09:07 AM

Thank you for responce.

I read the web sites and will download and try it.

But I didn't see anything about it stating this will work on SQl 97
(PC) to SQL 2000 (PC)?