PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues


Leave a Reply