I don't think this is a good Idea, Mike. The code you put in the transformation script is run for each row in the source table, so it would have to connect to the destination data source and issue a query for each row read from the source table.

I would copy the whole source table into a temporary table in the destination database and then match the rows with a set based query.

Hope this helps

Gianluca