SSIS Merge Join

I am working on an ssis package and i find an problem while using the merge join for merging 2 OLEDB Data sources .

data source 1 is : - The table formed my an sal server comand , that out put is given to a multicast since i want to sare that output amoung 2o other tables.

So the the left input for the merge join is OLEDB source , which contains direct data from source table

I am usong Inner join on one column

The problem is i am not getting the expected rows as out put of merge .

I tried to join the two tables in sqlserver query window and i am getting expected result

What could be the problem

The first table is

Reservations.ReservationManual

second table is Out put of the following query


Select Distinct B.ReservationID as R

from Property.Main A ,Reservations.Reservations B ,Reservations.ReservationRooms C

Where

A.propertyID = B.PropertyId And

C.ReservationID = B.ReservationID And

getdate() >=C.Until +A.ReservationOffLineDays




i am not getting the expected result here in SSIS package merge join

But if i try to execute the following in query editer in management studio i am getting the expected result !!



declare @temp as table

(ResID Varchar(50)

)

Insert into @temp

(ResID)

Select Distinct B.ReservationID as R

from Property.Main A ,Reservations.Reservations B ,Reservations.ReservationRooms C

Where

A.propertyID = B.PropertyId And

C.ReservationID = B.ReservationID And

getdate() >=C.Until +A.ReservationOffLineDays

select * from Reservations.ReservationManual A , @temp b

Where A.reservationID = b.resID