I created 4 Execute SQL task and each one is adding single row to the table. When I execute the package it is working fine. If I add these 4 tasks to Sequence container. The first Execute SQL task fails with the connection error. I checked the connection is fine and works fine without sequence container. I am using TransactionOption as Required for Sequence container.
[Execute SQL Task] Error: Failed to acquire connection "ABCDDB06\DEVDB007.dbBRIMS2". Connection may not be configured correctly or you may not have the right permissions on this connection.
Does anyone know why is the execution failing?