I am trying to use the merge join in ssis; however, when i am putting in two columns on basis of which i am joining it is giving me correct results. But as soon as I add more columns in one of the sources, it gives me matches with nulls only.
Asked
Active
Viewed 114 times
0
user2438237
- 315
- 2
- 4
- 16
-
Do you have an `order by` in both of your sources? Are the columns the same data type? Please post sample data – Nick.Mc Jan 07 '16 at 01:21
-
Hello @Nick.McDermaid : yes i have added order by in sql command (oledb source)while I am fetching the data. Everything works perfectly if I just fetch the fields on which I am joining but as soon as i add more fields it kind of craps out.. – user2438237 Jan 07 '16 at 17:35
-
You'll need to post screenshots of the Merge Join configuration for us to be able to help you further. – AHiggins Jan 07 '16 at 20:25
-
You'll have to provide more info. "Craps Out" is a useless description. – Nick.Mc Jan 09 '16 at 05:54