Data import from CSV to SQL Azure Database

Question

I am trying to load CSV file to Azure Database using SQL Server Import and Export Wizard. I am getting the following error message at "Copying to "dbo".mytest_table"...

Copying to "dbo"."mytest_table" (Error) Messages Error 0xc020844b: Data Flow Task 1: An exception has occurred during data insertion, the message returned from the provider is: Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again. (SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - mytest_table" (38) failed with error code 0xC020844B while processing input "Destination Input" (41). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)

crthompson · Accepted Answer · 2013-08-13 04:13:01Z

1

As you are setting up the mapping, do you create an primary key for new mytest_table? Also, look at the CSV properties, I believe there is a way to indicate the primary key column.

answered Aug 13, 2013 at 4:13

crthompson

15.9k6 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lee Cordell · Accepted Answer · 2015-09-06 19:31:03Z

1

For anyone that comes across this in the future: if you're just importing a sheet from excel that doesn't have a primary key, do the following:

Click the 'Edit Mappings' button at the 'Select Source Tables & Views' step. Click 'Edit SQL' and add the following at the end of the SQL statement before the closing bracket to add a calculated id field: , ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED

edited Sep 6, 2015 at 19:31

answered Sep 6, 2015 at 17:10

Lee Cordell

2863 silver badges9 bronze badges

Collectives™ on Stack Overflow

Data import from CSV to SQL Azure Database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related