Flat File to OLE DB

[Dukester0122]

Using SSIS 2005 and importing data from csv to a SQL server database and getting this message:

SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x80047076 at Data Flow Task, DTS.Pipeline: The output column "Item#" (12626) on output "Flat File Source Output" (12580) and component "Flat File Source" (12579) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

 

[AlexCuse]

Sounds like you have a source column not being placed in your destination. This would be a better question for the SSIS forum though.

forum1555

hope it helps,

Alex


Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.

 

[mrdenny]

That is exactally what it means. You don't have the Item# column mapped to an input column on your destination connection.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[AlexCuse]

That is pretty cool that SSIS points that out, although for some reason I am dreading the impending change over to SQL 2005 anyway...

Thank goodness they have allowed backwards compatibility for DTS (after only jumping through a couple of hoops)

Anyway, dukester - just deselect Item# as a source column (or add a destination column if you need it)

Thanks for clarification Denny

Alex


Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.