ERROR WHILE USING TRANSACTION PROPERTY

• rashu.patel

  SSC Journeyman

  Points: 96

  More actions

  October 8, 2009 at 1:27 am

  #216143

  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 ....

• sanoj_av2001

  SSChasing Mays

  Points: 601

  More actions

  October 8, 2009 at 5:46 am

  #1063365

  Post it in the SSIS fourm to get better response.

  http://qa.sqlservercentral.com/Forums/Forum148-1.aspx

  ..