SSIS package without using view table

[jj22171]

I'm trying to write an SSIS package with 3 important tasks. Task 1 queries from a couple of joined tables.
Task 2 queries from another couple of joined tables.
Task 3 joins results from Task 1 and Task 2 and write the results into a staging table.

My option at the moment is to use view for each query in Tasks 1 & 2, join both views and use it as source for Task 3.

What's the best option without using view since I find it so slow?

thanks

 

[mrdenny]

Create two data sources, and use a Merge task or a merge join task to join the recordsets together.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[jj22171]

Thanks, Denny.
My first attempt was not successful as it gave me more records than expected. Then I realized one of the source tables has lots of blank/null values in one of the key fields. Once they were filtered-out, Merge Task worked like a charm.

Thank you very much.