SSISDB catalog check data flow number of rows

sakuraime 2,321 Reputation points
2021-09-21T08:00:11.787+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,455 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2021-09-21T08:25:29.633+00:00

    No, SSISDB is just the storage & management for packages, you have to implement your own logging of the data processing.
    Integration Services (SSIS) Logging

    0 comments
  2. ZoeHui-MSFT 33,126 Reputation points
    2021-09-22T02:05:41.28+00:00

    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.

    ssis-catalog

    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

    0 comments