Friday, 24 November 2017

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/

1 comment:

  1. Privileged to read this informative blog on SSIS Issues. Commendable efforts to put on research the data on SSIS tutorial. Please enlighten us with regular updates on SSIS course. Friends if you're keen to learn more about MSBI training you can watch this amazing tutorial on the same:https://www.youtube.com/watch?v=mrv0e6Qa4_M

    ReplyDelete

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 fello...