Hi i am using sequence container and inside the container i am having 3 sql task (two for truncate table and one for delete tables)and 1 data flow task.when i am setting sequence container's transaction option to supported or required it is not working telling unable to establish connection and it is functioning well with not required .But when i use not required Rollback wont happen.So how i can solve it with transaction option required and run the package at the same time.