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.
catalog.create_execution_dump saves those files too but only works with projects