October 3, 2008 at 9:47 am
I'm looking for a way to log (or audit) row counts from Insert, Updates, and Deletes with the affected table names to a SQL Server 2005 table. For one package in particular, I currently have row count transforms in each of my DataFlows.
Is there a way to use the VariableDispenser to record information from User variables that contain information like this to a SQL Server 2005 table? I have searched the web for a model of this, but I haven't found anything. I'm hoping to come up with something fairly generic so that I can use it in any package.
Thank you for your help!
CSDunn
October 9, 2008 at 12:21 pm
I use a series of stored procedures for logging my package execution results. I keep row counts in variables as you describe and then log the results to a row in a table that keeps track of each execution of the package. We also log data errors in the same way. All of the procedures are generally executed from Exec SQL tasks on the control flow and are kept outside of any transaction used by the data flow. In that way, I get my execution results logged even if the updates performed by the data flow are rolled back.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply