I have ssis package inside SSISDB , the ssis package has some data flow tasks.
I would like to know if the SSISDB has some views to show the history of each data flow tasks where how many rows are involved ? thanks
I have ssis package inside SSISDB , the ssis package has some data flow tasks.
I would like to know if the SSISDB has some views to show the history of each data flow tasks where how many rows are involved ? thanks
Hi @sakuraime,
The SSISDB catalog is the central point for working with Integration Services (SSIS) projects that you've deployed to the Integration Services server. For example, you set project and package parameters, configure environments to specify runtime values for packages, execute and troubleshoot packages, and manage Integration Services server operations.
However SSISBD catalog could not check data flow number of rows.
You can use the Row Count Transformation in your package.
how-to-count-number-of-rows-inserted-or-updated-in-ssis
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
No, SSISDB is just the storage & management for packages, you have to implement your own logging of the data processing.
Integration Services (SSIS) Logging
15 people are following this question.