67 SSIS Transactions | Sequence Container in SSIS

[@arreak]

When I set TransactionOption to required to the container I am getting error that I cannot connect the database, any ideas?

[@rajeshwarithippelingappa3126]

Hi Aqil, I have a question that what if we set a property of transaction option to required outside the sequence container?will it rollback the transaction if any one task fails?

[@learnssis]

Yeah try to set the transaction option to required for the SSIS package and yes it should rollback the transaction if any one task fails.

[@rajeshwarithippelingappa3126]

@@learnssis thanks

[@dilipkumar-ck1nc]

Can u provide if statement code here and at every u r running the query u r executing from if statement and u r not dropping the table u r just truncating and running from if statement Ques: the table is already created at every time u r executing It has throw error

[@learnssis]

Hi Dilip, In this video I am showing and explaining how transactions work in SSIS, that's why I am truncating the table in SSMS. You can put the create table statement code in the SSIS package itself. Before the Create table statement I have put a if condition IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Names') AND type in (N'U')) So this code is checking if Names table exists or not. So If Names table won't exists only then the create table code will be executed, so the code will never fail.

[@mahlet2454]

Thank you so much. The tutorial is great and precise. My question is what if you have multiple rows in your insert statement and only a single record failed, does all data rollback or just unmatched records?

[@learnssis]

If you have not changed the default properties of OLE DB destination component, then in case of failure all data should be rollback. Thanks.

[@pratikshabhambore4731]

Very well explained..Great job by you

[@learnssis]

Thank you so much Pratiksha.

[@mostafafakhra]

I am watching your SSIS videos from the beginning and thank you so much for your perfect explaining but unfortunately in some videos like this one I can't understand or focus because of the kids shouting in the background of your videos. Thank you again.

[@learnssis]

ha ha. That family has shifted to new place now :) Now more kids here.

[@sachinraut1766]

Nice explained.Thank you

[@learnssis]

Good to know that you liked the video.

[@MonikaSharma-je2fc]

Thank you....... its simply explained well

[@learnssis]

Thank you Monika for your comment. Its nice to hear that you find the video useful.

[@kumarankit5702]

Excellent

[@Fullon2]

Hi my friend, when I use the sequence container, and I activate the distributed transaction service, my event error, which you taught in the video kzbin.info/www/bejne/boG8qpmpqdahotE&t stops working. Can you tell me why this happens?

[@learnssis]

Hey Phillepe, I created a new ssis project for your issue and did the similar thing as per the video and when my package fails then OnError event is getting triggered. This is the default behavior of SSIS. Sorry not sure what might be wrong in your case. Can you please create a new project and try again ?

[@Fullon2]

@@learnssis Hi, the event error is triggered, what doesn't work is the SQL task "Log Error" that you taught how to do in the video I sent. When I start the windowns distributed transaction service and simulate an error in the sequence container, the event error is triggered, but the "Log Error" task stops working, it only works when I disable the windows distributed transaction, then it works again, do the test.

[@tugbaakan7099]

It is well explained, thank you. But, I wish your pronunciation was better.

[@learnssis]

Good to know your response on it.

[@gregorytaylor2749]

I have learned by listening carefully to people speaking with different accents that I will learn to understand what they are saying.