SOS!!! Display RecordCount

Valeryia 1 Reputation point
2021-06-30T11:08:47.617+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,446 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,401 Reputation points
    2021-07-01T02:31:32.023+00:00

    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

    0 comments No comments