Error When using Add New ad Update Old Writer Transformation

Hello, My first attempt at using this.

Environment: AETL Pro x64 v6.3.2.18 with MS SQL Server

I receive an error from the ODBC driver of "Connection is busy with results for another command"

Screen shots attached,

In this case all of the source file records are already in the database and I am expecting an Update to occur.In fact the first row works and the target row is updated. In fact the updated causes a very small trigger to fire to update some audit fields (ModifiedBy etc) and this works for the first source record but it seems that the ODBC driver is waiting for some sort of response from the update and not getting it in a timely fashion before the next update/insert/count attempt is made.

I must be missing something.

Please put set nocount on inside the trigger

Ahhh. Thanks I had forgotten about that. I will give that a try