microsoft.public.sqlserver.server - DTS between SQL server 7.0 and 2000

Author

DTS between SQL server 7.0 and 2000

Mike Wade

2002-06-22, 8:31 pm

Yes I have done it before.

All DTS packages in SQL 7 should be fine in SQL 2000.

>-----Original Message-----
>I have two Windows 2000 servers. Both servers
>run SQL server 7.0. There are local DTS packages
>that transfer database objects(table, views, sp) between
>the SQL servers. Now I want to upgrade one of the
>SQL server from version 7 to version 2000 while
>keeping other server running SQL 7.0. I am concern
>the DTS transfer failure between different SQL
>server version! Have anyone done DTS transfer between
>MSSQL server 7.0 and MSSQL server 2000?
>.
>

Sponsored Links