Data flow Task insert errors to a general package error handler?
hi,
in package have 50 data flow tasks ole db sources , destinations in them. every time when insert error between source , destination occurs want handler write errand records log table.
1 solution attach ole db command log writer procedure error output of each ole db destination. have make 50 times cause have 50 dataflow tasks.
use 1 general handler whole package.
logic be: dataflow (ole db source->ole db dest) on record insert error , package error handler writes record log table.
idea? thanks!!
greetings no planet!
hi
you can 1 thing, put 50 data flow tasks in sequence container in control flow , generate 1 event log handler sequence container.
inside sequence container, if want run 50 data flow tasks no matter 1 fails, join them via completion precedence constraint.
SQL Server > SQL Server Integration Services
Comments
Post a Comment