Post reply

Importing SQL Server 6.5 database to SQL Server 2000 Using DTS Import/Eport Wizard

  • December 28, 2009 at 11:14 am

    #75547

    Hello,

    I am trying to import a SQL Server 6.5 database into a SQL Server 2000 using DTS Import/Export Wizard. However, when I get to the "Select Soutce Tables and Views" window of the utility I get the following error:

    Error Source: Microsoft OLE DB Provider for SQL Server

    Error Description: Invalid column name 'My Column name'

    Context: Error calling OpenRowset on the provider

    1. Is this a valid process (DTS Import/Export Wizard) I am using to import my database?

    Thanks for your help.

  • December 29, 2009 at 11:05 am

    #1097148

    Unfortunately - you can't do that. The conversion from 6.5 to SQL 2000 (aka 7.0) was a Major conversion that required you to perform conversion using the SQL 2000 installation. The last time I did that was over 10 years ago, but this definitely was not a quick "detach and reattach" conversion at all!

    You may want to consider scripting "Create table" scripts from Enterprise Manager, and then copying the data via command line "bcp". You can look that up via BOL. Good luck!


    Todd

  • December 29, 2009 at 11:26 am

    #1097162

    Thanks, I will look at your recommended process; hopefully it works for me.

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

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