Importing Data From a Flat File

Hi,

I am trying to import data from a Flat File in SQL Server 2005, this used to be a simple task in SQL2K but for some reason isn't in SQL2K5.

I am only trying to import part of the record not the whole thing and it keeps giving me this error:

**************************************************************

MessagesWarning 0x80047076: Data Flow Task: The output column "Column 3" (19) on output "Flat File Source Output" (2) and component "Source - consumer_0_dat" (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 "Column 3" (19) on output "Flat File Source Output" (2) and component "Source - consumer_0_dat" (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)

******************************************************************************

If I delete the columns and only have those that I want inserted then i get column length errors.

Can someone pls provide instruction to import a flat file in my database?

Thanks

These are just Warnings, this should not stop your package from execution, unless there is error happening somewhere else.