• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 79
  • Last Modified:

transactions in SSIS

I have 3 dataflow tasks in a row that insert records.  If anything at all fails during the dataflow task i want everything to get rolled back.  For some reason i am not seeing a transaction task.  It there something like that?
0
vbnetcoder
Asked:
vbnetcoder
1 Solution
 
Petros NasisCommented:
Hi,

Check here (https://msdn.microsoft.com/en-us/library/ms141144.aspx)

Normally you have to Update the TransactionOption to (Required)

Hope that helps!
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now