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?
A.
WarnAsError
B.
Dump
C.
DumpOnError
D.
Logger
Explanation:
Dump error code
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 (;).