how to rollback ssis package without msdts

See more:

SQL

SSIS

example

In SSIS i have

Begin Tran

in sequence contaner

Connection DB test1
1,Sql task -CREATE TABLE test_ID (ID int)

2.Sql task-Insert fields ---INSERT INTO EMPLOYEE_ID1 VALUES (5)

3.Sql task-Execute failure()---

select 1
union
select 1,2

In precedence Containor

Commit tran and Rollback tran

So senario when MSDTS (Distributed transaction services) is disabled when transaction failed evry thing to rollbacked