Post reply

DTS Datapump to SQL Server 2005

  • March 23, 2007 at 8:42 am

    #194802

    I have a datapump package on one server that currently pumps data into a couple of other databases on different servers.  The databases on the other servers may be upgraded to sql server 2005, however there are currently no plans to upgrade the local installation. 

    My questions are:

    What changes will I possibly have to make? (i.e. will I have to make any changes to the Microsoft OLE-DB Provider for SQL Server?)

    Does anyone know of a resource for this type of thing? All I can find is information about upgrading to 2005 and SSIS.

    Thanks,

    Bob McC

  • March 23, 2007 at 9:40 am

    #696648

    Bob,

    You should be able to run the package with no changes.  I've created a package in SQL  2000 that exports data to a database in a SQL 2005 instance and it worked fine.

    As for resources, you could check http://www.sqlis.com. 

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply