Thanks. First the data flow component.

Flat File Source (csv) >> Row Count Transform pointing at table in db for row count audit>> OLE DB DataSource pointing to db and destination table

In Control flow component...

I use a For Each Loop to go move through a directory with several .csv files, audit rowcount, and archive the file that has been processed.

It seems like Flat File Source defaults to a to a string(50) even though the destination table has the proper field sizes set up per data dictionary.

I'm relatively new with this, as I'm sure you can tell. 🙂 I appreciate your help.

bph