I am trying to handle errors occurring at every stage of importing data from csv files to Staging table to the final stage of storing data into target table.
While doing so, I am trying to use the Update activity to store error counts at stage through $(vars.recCount).
Error handling through the Update activity seems to be an overhead and causing multiple issues. So as a workaround, I am planning to use SQL Code activity to store all the error record counts at each stage of data loading. I am trying to write usual sql code but getting error.