Peculiar problem regarding Transactions

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 7, 2007 at 9:27 pm

  #115854

   Hi

  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"

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 7, 2007 at 10:49 pm

  #681700

  Did you add the precidence between three tasks?

  MohammedU
  Microsoft SQL Server MVP

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 8, 2007 at 3:31 am

  #681729

  hi

  I figured out what was happening. MSDTC was not properly configured, I configured it and things started moving.

  Thanks anyways

   

  "Keep Trying"