Run SQL command tasks against company databases in the map
Kevin, If you are on the latest versions of SmartConnect then the best approach may be to just add the taUpdateCreateAccountRcd in with the existing Transactions nodes (using Node Maintenance). You can add it twice, (one that runs before the lines and header and then one that runs after). If you do it this way then it will take the context of the company you are bringing the transactions into. Another way would be to use a piece of data in your source that indicates which company and pass that in as a parameter in the SQL Script. Something like below:
update _myDataField..GL00100 set ACCTENTR = 1 WHERE Account = myAccount.