question

sakuraime avatar image
0 Votes"
sakuraime asked Zoehui-MSFT edited

SSISDB catalog check data flow number of rows

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-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT edited

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.