How to Rollback Transaction in SSIS ?
I have created a table as
Create table Temp (ssn int not null PRIMARY KEY CLUSTERED (ssn),FName varchar(50),LName Varchar(50))
and i am having a text file with data
I used Source Flat File Source and for Destination OLE DB Destination
and run the pack.
All the 6 records are inserting into the table but i dont want to insert them if there is a Violation of PRIMARY KEY then it should rollback the transaction.
I tried Sequence Container where the datas are not rollback
How to rollback the transaction
Find the attached sample