Sequence container issues

• kiruthika.naren

  Valued Member

  Points: 50

  More actions

  May 2, 2011 at 6:34 am

  #389416

  Hi ALL,

  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.