SOS!!! Display RecordCount

Question

Hello,
Maybe someone knows how to display RecordCount in logs on SQL Sever Side. After running SSIS package I have only NULL values.

Thanks in advance

Answer 1

Hi @Valeryia ,

You may try below methods:

1.Using Execute SQl task, get the count store it in variable and then use the captured variable value to the Log provider.

2.Row Count Directly in the Control Flow, and map that in your Logging.

3.Log SSIS Variable Values During Execution in the Event Log.

Details please refer:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/64ab1ec3-b0f2-4bba-9523-a7bcd6c154f1/ssis-logging-recording-record-count-from-sql-task?forum=sqlintegrationservices

http://www.sqlerudition.com/how-to-log-ssis-variable-values-during-execution-in-the-event-log/

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October