SSIS Issues : A Day of Learning

,

Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.

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

Solution 
#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.

Solution
Remove the OLEDB Source and drag n drop a new one.

"Life is 10 % what happens and 90 % of how you react to it."

Thanks
Lokesh

https://www.linkedin.com/in/sqlbideveloper/

Rate

Share

Share

Rate