Importing from a Flat File

I have a flat file which has five fields, and need to import into a table that has 6 fields, the first of which will be data from a variable.

i have Used a Dataflow task which has a flat file source task . i need help to get the data from that into the table

Table field1 field2 field3 field4 field5 field6

@.Variable

File Col0 Col1 Col2 Col3 Col4

can anyone explain how i can achieve thsi

I would suggest using a derived column task to add a column to the pipeline that can be set to your variable.

Then I would use an OLE DB destination. You can set the target table in the OLE DB Destination.

Place the derived column task right after the flat file source then pipe the data into the destination.

HTH

Mark

http://spaces.msn.com/mgarnerbi