SQL Server 2005 Import Wizard fails 2nd time

Question

In the process of moving mutliple databases, so I ran the data import wizard on the 1st database and it ran fine - everything imported correctly.  The 2nd time, i.e. when I ran the wizard for the 2nd database, I got the following error:

- Execute the transfer with the TransferProvider. (Error)

Messages

ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [BESMgmt].[dbo].[vMDSConfig] (
[BESServerName] nvarchar(256),
[SRPuId] nvarchar(256) NOT NULL,
...
)
" failed with the following error: "There is already an object named 'vMDSConfig' in the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

So I renamed vMDSConfig, and reran the wizard.  The next time I got the same error message for the table MDSDailyStat.  So I repeated the process and then got an error for MDSHourlyStat, followed by:

MDSmonthlyStat
MDSquarterHourStat
ServerCapsALPV
....and on and on.

apparently something didn't get cleaned up after the 1st import.

Anyone know how to fix this?

Answer 1

Apparently the wizard doesn't like the the tables already exist.  If I delete the existing tables, the wizard completes fine.

Answer 2

Alex,

When you are in Select Source Table and Views window of SQL Server Import/Export Wizard and you click on Edit Mappings, options are provided with regards to the destination table including Drop and Recreate.  You can also edit the CREATE TABLE script.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com