Database Reference
In-Depth Information
Figure A-16 . Adding the Log Error Execute SQL task to the Parent Package OnError event handler
Test the new error logging functionality by running Parent.dtsx in the SSDT
debugger. When prompted from the ErrorTest.dtsx package, click the No button
to generate an error. In SSMS, execute the following query to examine the error
metadata:
Select * From log.SSISErrors
The results should appear similar to those shown in Figure A-17 .
Figure A-17 . Error metadata in the log.SSISErrors table
As you can see from the preceding image (and hopefully your own code if you are
following along at home), error logging can make trouble shooting SSIS issues much
simpler.
 
 
 
Search WWH ::




Custom Search