Phil Parkin (12/3/2010)
Or ...Instead of using the tables as your sources, use a query which includes the join. Then your data source is ready to go - this will be faster than MERGE JOIN in SSIS.
HI Thanks for the reply
it worked by selecting outer join but out put is
1210NULLNULL
NULLNULL66667
NULLNULL98665
377467NULLNULL
123156NULLNULL
iam expecting the below one
a b x y
121066667
37746798665
123156NULLNULL
how to get like the above one