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