I have a question....In my SSIS Package I need to do this kind of calculation : if Count(Status==C) >= 1 ...Then Get only those records.... from the incoming flow...
My Status Column Values will be C,B,D
My input source is Oracle.... In the middle of the flow I need to do this calculation....
I know how to acheive this using look up transform.....Is there any other transformation other than lookup which I can use... inorder to acheive count of status = c >= 1...?
If so..can you let me know ASAP...
Appreciate your responses.
View Complete Post