sql - How do I incorporate MERGE into my SSIS Data Flow Task? -

i trying prevent duplicates when i'm inserting values staging table primary table. have 2 components: ole db source points ole db destination.

in ole db source, had this:

select [qvw names] 'qvw name', '1' 'qvw type' dbo.stg_qvd_generator [qvw names] <> '' union select [qvw names] 'qvw name', '2' 'qvw type' dbo.stg_data_models [qvw names] <> '' 

to prevent duplicates, researched , began testing out new query using sql server management studio, able this:

merge qvw_files tbl  using (select [qvw names] 'qvw name', '1' 'qvw type'        dbo.stg_qvd_generator        [qvw names] <> ''        union        select [qvw names] 'qvw name', '2' 'qvw type'        dbo.stg_data_models        [qvw names] <> '') src  on (tbl.qvw_name = src.[qvw name] , tbl.qvw_type_id = src.[qvw type])  when not matched       insert (qvw_name, qvw_type_id)      values (src.[qvw name], src.[qvw type]); 

and seems prevent duplicates being entered target tables staging tables. however, entered ole db source , realized return no columns because not select statement. how can incorporate data flow task?

thanks.

you can use merge or merge join transformation in ssis. create data flow task, setup each of source tables ole db source objects, , use merge or merge join, , set destination table.