Import errors from Excel to SQL 2005 DB Table
How frustrating is this, all I want to peform is a one column to one column Import here!
Why am I getting this error when simply trying to import from my excel workbook to my table? I know excel has a 255 char cell, but I specified to only account for 100 characters during the SSIS Import wizard in Management Studio. This is using SQL 2005.
See the setup herehttp:
Then I get this error during the import:
Validating (Error)
Messages
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.
(SQL Server Import and Export Wizard)
Warning 0x80047076: Data Flow Task: The output column "F2" (18) on output "Excel Source Output" (9) and component "Source - 'Root Levels$'" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.
(SQL Server Import and Export Wizard)
Warning 0x80047076: Data Flow Task: The output column "F2" (18) on output "Excel Source Output" (9) and component "Source - 'Root Levels$'" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - 'Root Levels$'" (1).
(SQL Server Import and Export Wizard)
My Excel doc simply has 2 columns of text, the second I'm ignoring. I am only importing the first column.
