SSIS Script component Transaction
I am trying to use script component as transformation for processing a non
formatted flat file.
I can achieve everything, but i would like to fail the component as well
as the parent component holding it. The target is a oleDB destination.
When i redirect the rows it goes and writes the row. But if there is any
error in the file it should rollback everything for the relevant file and
go to the next file for processing.
Any insight how can i get that worked? I have tried manytimes but if the
exception is handled with try catch block the component doesn't fail. Any
even if it fails it doesn't go to the next file for processing.
No comments:
Post a Comment