I have a sequence container. Inside that i have one dataflow task. and few more tasks. I want to rollback the transaction if it fails.
so i set the Transaction levle properties as
Isolation level - serializable
Transaction option - required.
But still my package fails with the following error.
[Execute SQL Task] Error: Failed to acquire connection "LX-KCRP8FW_2.PLGBA.plgba". Connection may not be configured correctly or you may not have the right permissions on this connection.
kindly help me.