Forum Discussion
Sudhakar2301
Feb 08, 2024Copper Contributor
Importing excel data in SQL Server 2022 getting error not able insert into SQL DB location table
I am unable to add the data into SQL DB location table. Messages Error 0xc002f210: Drop table(s) SQL Task 1: Executing the query "drop table [dbo].[dbo.Table1] " failed with the following error: "...
rmeldrum
Feb 13, 2024Copper Contributor
It is referring to the table [dbo].[dbo.Table1]. Try taking out the schema name when you specified the table as it looks like it has put the schema in there twice.
Fir the View Report error try setting all the column types to VARCHAR(MAX) and try again
Fir the View Report error try setting all the column types to VARCHAR(MAX) and try again