January 7, 2007 at 9:27 pm
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"
January 7, 2007 at 10:49 pm
Did you add the precidence between three tasks?
MohammedU
Microsoft SQL Server MVP
January 8, 2007 at 3:31 am
hi
I figured out what was happening. MSDTC was not properly configured, I configured it and things started moving.
Thanks anyways
"Keep Trying"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply