Transactions in SSIS

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 3, 2007 at 2:16 am

  #115673

  Hi all

  To learn transactions in SSIS i have a created a simple package having 3 execute sql tasks. First task creates a table,second tasks inserts proper data and the third task inserts bad data (character data into a integer field) and will fail.

  Following properties have been set

  For the package - TransactionOption - Required

  For the 3 tasks - TransactionOption  - Supported

  When i execute this package the first task turns to yellow and then it just stays like that. output window shows this message

  "SSIS package "Package.dtsx" starting. Information: 0x4001100A at Package: Starting distributed transaction for this container." 

  After this nothing seems to happen.

  ThankYou

   

   

  "Keep Trying"

• January 8, 2007 at 8:00 am

  This was removed by the editor as SPAM

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 8, 2007 at 9:22 pm

  #681937

  have figured out what is happening.

  "Keep Trying"

• Agson Chellakudam

  Ten Centuries

  Points: 1387

  More actions

  January 10, 2007 at 5:51 am

  #682342

  Hi Chirag,

  I couldn't simulate the problem.

  I just set the trasaction options you have provided. ('Required' to package and 'supported' to all three SQL Tasks). 

  For me first two tasks are running successfully andthird one is failing as expected and rolling back all the 3 tasks activities! .

  Regards,

  Agson Chellakudam