SQL Server : Executing the query "CREATE TABLE [dbo].[###] (Column 0] v..." failed with the following error: "There is already an object named '###' in the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly

When I was Importing data from a flat file, I met with the below error:
Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[###] (
[Column 0] v..." failed with the following error: "There is already an object named '###' in the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
At very first sight, I couldn't understand. But after some investigation found the resolution.


Solution:
Open your database and search for table ###, if it is already there, remove it or rename it.
Try running the Import wizard again.... hope you will get it done.

By
image credit: http://www.tailwindtech.com
Posted By AlpesH Shah Labels: ,

1 comment:

  1. UnknownThursday, 03 April, 2014

    unfortunately that's the reported (from error log) reason for the failure, but in my case not the solution. I drop the existing table, but error remains.

    ReplyDelete

Subscribe to: Post Comments (Atom)