Merge and Join

Hi I am a newbie into the world of Microsoft SQL Server Integration Services 2005. I am trying to merge 2 tables using a specified join like equi-join and also having a complex set of critriea. And I know if I use the merge/merge join transformation it can't be done so how to go about doing that other than using the "Execute SQL Task" which doesn't help me in my next "Data Flow task" as an input. As i need the data derive from the complex sql as an input to other transformations.Hi Ken Hu

could you be a bit more specific about what you are trying to achieve ? (eg: by giving us some pseudo-code ?).

This way more people will be able to give you bits of answers.

cheers

Thibaut