You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues

You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A
package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A
package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

A.
Execute the catalog.add_data_tap stored procedure with the package execution_id.

B.
Execute the catalog.create_execution_dump stored procedure with the package execution_id.

C.
Run the DTEXEC utility with the /DumpOnError option.

D.
Run the DTEXEC utility with the /Reporting V option.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


mike

mike

Ignore my previous comment.
C is correct, as the question states that it uses Package Deployment model.