Jim Horn
asked on
How to handle Try/Catch error handling in Source task within a data flow
Hi All
I have an SSIS package with a number of data flow tasks with OLE DB Source tasks that execute SP's.
I'd like SP to have the ability to return somewhat English-sounding error message if an error occurs within the SP.
Doing this within a SP using a TRY/CATCH block is no biggie, but I'm trying to figure out how to handle this within my SSIS data flow task.
As far as I can tell, with OLE DB Source tasks if there is any difference between what is returned, and what is pre-mapped to an OLE DB Destination task, SSIS will throw a runtime error, with different error properties that what would be trapped by a TRY..CATCH block within T-SQL.
Has anyone pulled this off?
Thanks in advance.
Jim
I have an SSIS package with a number of data flow tasks with OLE DB Source tasks that execute SP's.
I'd like SP to have the ability to return somewhat English-sounding error message if an error occurs within the SP.
Doing this within a SP using a TRY/CATCH block is no biggie, but I'm trying to figure out how to handle this within my SSIS data flow task.
As far as I can tell, with OLE DB Source tasks if there is any difference between what is returned, and what is pre-mapped to an OLE DB Destination task, SSIS will throw a runtime error, with different error properties that what would be trapped by a TRY..CATCH block within T-SQL.
Has anyone pulled this off?
Thanks in advance.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Pretty much the answer I was expecting, as SSIS doens't handle one schema for success, another schema for errors.
Thanks.
Jim