Data import from CSV to SQL Azure Database -
i trying load csv file azure database using sql server import , export wizard. getting following error message @ "copying "dbo".mytest_table"...
- copying "dbo"."mytest_table" (error) messages error 0xc020844b: data flow task 1: exception has occurred during data insertion, message returned provider is: tables without clustered index not supported in version of sql server. please create clustered index , try again. (sql server import , export wizard)
error 0xc0047022: data flow task 1: ssis error code dts_e_processinputfailed. processinput method on component "destination - mytest_table" (38) failed error code 0xc020844b while processing input "destination input" (41). identified component returned error processinput method. error specific component, error fatal , cause data flow task stop running. there may error messages posted before more information failure. (sql server import , export wizard)
as setting mapping, create primary key new mytest_table? also, @ csv properties, believe there way indicate primary key column.
Comments
Post a Comment