minglelinch
asked on
importing problem
I'm importing an excel sheet data to a table. There's no foreign key in this table. There's no calculation fields. I got quite some lines of warning as below which failed my importing.
How can I correct it? I did not see any extra unsed columns in excel sheet. Thanks.
- Validating (Warning)
Messages
Warning 0x80047076: Data Flow Task: The output column "Schl" (15) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Cluster" (18) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Address" (21) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Zip Code" (24) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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)
How can I correct it? I did not see any extra unsed columns in excel sheet. Thanks.
- Validating (Warning)
Messages
Warning 0x80047076: Data Flow Task: The output column "Schl" (15) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Cluster" (18) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Address" (21) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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 0x80047076: Data Flow Task: The output column "Zip Code" (24) on output "Excel Source Output" (9) and component "Source - 'Schedule$'" (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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER