Hi All,
Whenever im trying to use the Transaction Option as "Required" , its always showing below error .
[Execute SQL Task] Error: Failed to acquire connection "ABC.AdventureWorks2008.XYZ". Connection may not be configured correctly or you may not have the right permissions on this connection.
I have jus put 3 simple Exceute SQL task in a sequence container and then have enabled the Transaction Option as "Required" . But then its throwing error . But then when i make the Transaction Option as "Supported" its working damn fine .
Please opine ....