SSIS Script component Transaction

Question

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.

can you post some of your scrip? – TsSkTo Sep 09 '13 at 09:37 — TsSkTo, Sep 09 '13 at 09:37

score 0 · Accepted Answer · answered Sep 26 '13 at 19:08

0

I had found similar solution to the problem. Adding sql tasks before to start transaction and checking with variables in precedence constraints i was able to commit or rollback the changes made to the Oledb Destination in my DFT.

Thanks

answered Sep 26 '13 at 19:08

Linu1988

49
3
8

SSIS Script component Transaction

1 Answers1