Hi,
I'm having trouble to get complete resultset from a Lookup component between 2 tables having join keys as uniqueidentifier datatype.
In Management Studio using SQL statement on the same tables (inner join) on the same keys I've got 36 rows.
On SSIS 2008, using Lookup component on the same keys I've got only 1 row and nothing else more on any output from the component. I've tried more than a half a day to figure out what's happening...but still not found enything...I'm getting very frustrated here.
Does anybody has the same problem before...?
Help will be very, very, very appreciated...
Cheers,
Oks
SQL SERVER 2008 ENTR EDITION x64