Hi All,

i have a for each loop that reads files from a specific directory. imports
the files and performs a sql task on each file.

now the powers that be would also like a audit trail on the filename and the
date that it was inserted into the database.

i am using a OLEDB connection to import the files, i create the variables
pass the filename to the dataflow so that it can be imported into a sql
table.

does anyone have a good sample or website that allows you to pass a variable
to a execute sql task for inserting into a table

many thanks
Simon Whale