SSIS Transaction when st to required error occurs.

• divyasisa

  Newbie

  Points: 3

  More actions

  September 26, 2014 at 2:39 pm

  #311891

  I am having an issue which is breaking my head. My SSIS package is working fine if the transaction property is set to 'Supported' but if I set it to 'Required', the package fails at the task which has its transaction set to required.

  --I have started the DTC service in both my system and server.

  --Have the tcp port 135 open.

  --windows firewall allows DTC.

  Even then it is failing. Any help would be great..

  Thanks in advance,

  DD