Update Table From Flat File Source

Hi all,

I'm trying to work out how to update a table from a flat file source.

I could use the simple way of using OLE DB Command with

UPDATE <tblName> SET Column1 = ?, Column2 = ?, <etc> WHERE ID = ?

then using the mapping to join the parameter fields.

However, this (maybe!) a slow process when you have potential 500k+ records in the source file (and approx 150 files to process!)

What I would like to do is the following statement but I'm not sure if this is possible?

UPDATE <tblName> SET Column1 = sourceColumn1, Column2 = sourceColumn1, <etc> FROM <sourcefile> WHERE ID = sourceID

I've also thought about importing the sourcefile into a Recordset Destination and trying to use the variable in the SQLCommand but I'm not sure how to do this...

Does anybody have any ideas on how this could work or an alternative solution?

Thanks in advance....