I would like to show the user the progress of SSIS packages in a c#-application (something like a progressbar)
My approach is to implement an audit table containing entries for every process. Within the runtime of the process I would call a procedure which updates the status (10%, 20%, ..., 100%) of the corresponding audit-record. The c#-application would have to pull the status.
Can I call a procedure with in a datapipe after let's say every 10000 rows? Can I achieve this without much loss of performance?
Can SSIS-Events help me? If so, could you describe this?