Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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)
0
minglelinch
Asked:
minglelinch
1 Solution
 
Jared_SCommented:
Are there any other errors?

These are just warnings that those columns don't hold any data. They suggest that you remove them from your import - but you don't have to.

It shouldn't fail your import.
0
 
minglelinchAuthor Commented:
Thank you. You are right.  I got it successfully done this time.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now