Thanks to Larry Page and my fellow developers :-).
But jokes apart I learned something new today and that always feel wonderful.
Issue #1:- Unable to enlist in the distributed transaction
Symptom:- Running a package (having sequence container and TransactionOption property set to required) on your local machine
#1: Activate all the options for MSDTC (Distributed Transaction Cordinator)
#2: Set the TransactionOption property to Supported
Issue #2:- The OLE DB Source.Outputs[OLE DB Source Output].Columns[XXXXXXXX] on the non-error output has no corresponding output
Symptom:- You will get the error message on OLEDB Source particularly when you add extra columns after the initial design/development of the package.
Remove the OLEDB Source and drag n drop a new one.
"Life is 10 % what happens and 90 % of how you react to it."