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