July 28, 2015 at 5:55 am
Hi Team
I have a SSIS package which has lot of tasks like for loops, sql tasks etc.
When I set TransactionOption to required , I get the below error:
[Execute SQL Task] Error: Failed to acquire connection . Connection may not be configured correctly or you may not have the right permissions on this connection.
When I change it to 'Supported' or 'Not supported', it runs fine.
I dont have an option to change this setting as its from production DB and need to keep it as is.
Now my SQL team said the MSDTC is enabled on SQL server and it's also enabled on the SSIS server where I am executing this package.
I have read there can be some firewall issues which can cause this, but i am not sure what do I need to check for that.
Could someone please provide some pointers on this issue.
August 5, 2015 at 6:04 am
Is the distributed transaction coordinator service started on all machines involved in the transaction?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply