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.
Correct answer should be B, since the package is deployed to SQL Server.
https://technet.microsoft.com/en-us/library/hh231095(v=sql.110).aspx
Ignore my previous comment.
C is correct, as the question states that it uses Package Deployment model.