What task can I use to get data from a field coming from a flat file?

[aldi]

Hello all,

I built a ssis package in sql 2005 and I need to get the value of one of the fields for every record, before it is writen to destination. What can I use/do?

Source: Flat File. Destination: SQL Server DB Table

This is the scenario:

I have orders uploaded to my ftp server nightly.

Every order is made up of two files:

One flat file with the order details, and
One pdf file with the artwork

Each flat file contains only one row, and one of the fields in the row contains the name of the pdf file (which is the one that I want to capture).

After each record is stored in the destination table, its correspondig flat file is moved to an archive folder.

THIS IS WHAT I NEED THE PACKAGE TO DO RIGHT AFTERnot shouting)

Move the corresponding pdf file (the one that comes with the order) using the pdf file name that comes in one of the fields of the flat file.

This is how I have the package now:

Control Flow tab:

One ForEach loop container with a Data flow task inside connected to a File System task (which moves each flat file that has been processed to an archive folder).

Data Flow tab:

One Flat File source connected to one OLE DB Destination

As it is now, it is working, but I need to move the pdf file from the uploading folder to an archive folder.

How can I get the value of the field containing the pdf file name?

I'll greatly appreciate your help!!!

Thanks in advance