Azure SSIS Runtime running SSIS package monitoring

sakuraime 2,326

In SSMS , right click the SSISDB catalog we can view the package running report .
are there similar way to check on Azure data factory , when the SSIS package is triggered from ADF ?

Like monitoring the progress of the task in the package /output messages .......

sakuraime 2,326 Reputation points

2021-08-26T07:02:47.437+00:00

anyone has the idea ?

1 answer

KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2021-08-26T15:31:40.26+00:00
Hi @sakuraime ,

Thanks for using Microsoft Q&A forum and posting your query.

Currently you can use the Azure Data Factory portal to check the output of the SSIS package execution activity. The output includes the execution result, error messages, and operation ID. For details, see Monitor the pipeline.

To check the detail logs for the execution, you will have to use the SSIS catalog (SSISDB). For details, see Monitor Running Packages and Other Operations.

Hope this info helps.

----------

Please accept an answer and up-vote if it helps. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.
KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2021-08-30T03:44:28.43+00:00

Hi @sakuraime ,

We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

sakuraime 2,326 Reputation points

2021-08-30T04:42:13.927+00:00

can you capture the screen how can I do that ? I mean monitor each of the single tasks/data flow performance/progress inside the SSIS package which triggered from Azure data factory .

KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2021-08-31T03:17:49.307+00:00

Hi @sakuraime ,

Thanks for getting back. As I mentioned in my earlier response you can only check the output of the SSIS package execution activity from Azure Data factory. The output includes the execution result, error messages, and operation ID. And for detailed logs of the execution, you will have to use the SSIS catalog (SSISDB) and not possible from ADF.

Look for SSISDB execution ID (Operation ID) from the output of the pipeline activity run and use the ID to check more comprehensive execution logs and error messages in SQL Server Management Studio.

sakuraime 2,326 Reputation points

2021-09-01T01:59:07.697+00:00

what about if the adf execute the package which store on azure files ?

KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2021-09-03T09:51:01.89+00:00

Hi @sakuraime ,

Thanks for getting back. The logging path can be provided in activity.

Please refer to this doc for more details: https://learn.microsoft.com/azure/data-factory/how-to-invoke-ssis-package-ssis-activity#package-location-file-system-package

sakuraime 2,326 Reputation points

2021-09-03T13:28:25.93+00:00

ok . so these include verbose log /?

ShaikMaheer-MSFT 38,456 Reputation points Microsoft Employee

2021-09-08T18:02:47.47+00:00

Hi @sakuraime ,

Below documentation links has complete details about running SSIS package using Execute SSIS activity in azure data factory. May be this will help you.

https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-ssis-activity

https://learn.microsoft.com/en-us/azure/data-factory/ssis-integration-runtime-ssis-activity-faq
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure SSIS Runtime running SSIS package monitoring

1 answer

Your answer