I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore
if no change.
I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.
example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it
and type_cd (decimal(18,0)) with values(0,1,2,3,4,5)
It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer
what i found is for all the llokup columns its having nulls (no match found).
Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected.
Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again
View Complete Post