Microsoft
70-458 · Question #29
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is…
The correct answer is A. Add an OnError event handler to the SSIS project. See the full explanation below for the reasoning.
Question
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?
Options
- AAdd an OnError event handler to the SSIS project.
- BUse an msi file to deploy the package on the server.
- COpen a command prompt and run the gacutil command.
- DOpen a command prompt and run the dtutil /copy command.
- EOpen a command prompt and run the dtexec /rep /conn command.
- FOpen a command prompt and run the dtexec /dumperror /conn command.
- GOpen a command prompt and execute the package by using the SQL Log provider
- HCreate a reusable custom logging component and use it in the SSIS project.
- JConfigure the output of a component in the package data flow to use a data tap.
How the community answered
(31 responses)- A74% (23)
- B6% (2)
- C13% (4)
- G3% (1)
- H3% (1)
Community Discussion
No community discussion yet for this question.