Microsoft
70-458 · Question #121
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. A package in the project extracts data from a Windows Azure SQL Database database. The…
The correct answer is A. Execute the catalog.create_execution_dump stored procedure with the package. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) project by using the Project 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?
Options
- AExecute the catalog.create_execution_dump stored procedure with the package
- BRun the DTEXEC utility with the /Reporting V option.
- CRun the DTEXEC utility with the /Logger option.
- DExecute the catalog.add_data_tap stored procedure with the package execution_id.
How the community answered
(56 responses)- A75% (42)
- B4% (2)
- C7% (4)
- D14% (8)
Community Discussion
No community discussion yet for this question.