70-448 · Question #196
You develop a SQL Server 2008 Integration Services (SSIS) package. You discover that the package fails and returns an error code of 0x80040E4D. You need to ensure that the package generates the…
The correct answer is B. Dump. Creates the debug dump files, .mdmp and .tmp, when one or more specified events occur while the package is running. The error code argument specifies the type of event code--error, warning, or information--that will trigger the system to create the debug dump files. To specify…
Question
You develop a SQL Server 2008 Integration Services (SSIS) package. You discover that the package fails and returns an error code of 0x80040E4D. You need to ensure that the package generates the debug dump files that are associated with the package only when this error code occurs. Which DTExec command line option should you use?
Options
- AWarnAsError
- BDump
- CDumpOnError
- DLogger
How the community answered
(32 responses)- A3% (1)
- B72% (23)
- C16% (5)
- D9% (3)
Explanation
Creates the debug dump files, .mdmp and .tmp, when one or more specified events occur while the package is running. The error code argument specifies the type of event code--error, warning, or information--that will trigger the system to create the debug dump files. To specify multiple event codes, separate each error code argument by a semi-colon (;).
Topics
Community Discussion
No community discussion yet for this question.