sql server - Guidelines for using Merge task in SSIS -

I have a table with three fields, an area of ​​identification, and I want to add some new records from that source The other two fields I am using SSIS, and I think I should use the merge tool because one of the sources is not in the local database but, I am confused with the merge tool and the proper process.

I have one source (an oracle table), and I get two fields, well _ID and well_nA, well_id. I have a Destination Table (SQL Server), and I'm also using it as a source. It has three fields: well_key (identity field), well_id, and well_name, and then I have a sort of job, which has a good e-mail. These are inputs for my merge function. I was going to produce in a temporary table, and then somehow new records get back in the SQL Server table

  Oracle Well SQL Well. | VV sort sort sort ------- & gt; Merge * & lt; ----------- | V temkara table well  

I suspect that this is not the best way to use the tool, though. What are the proper steps to merge this way?

One of my reasons for asking questions on this method is that there is an error in my merge, let me know that "merge input 2" should be sorted, but its source is a sort job, so it Has been sorted.

Example data

  SQL Well (before merge) well_key well_id well_name 1 123 well k 2 292 well c3 344 well t5 43 9 well D ORACLE VAL Well WellName 123 Good K 292 Well 311 Well 344 Well T 439 Well D532 Good J SQL Well Well (After Merge) Well Well Well Well Well well well_I_Name 1 123 good k 2 292 well c3 344 good Like the T-5 43 9 well as what would be better to load my Oracle in a temporary local file, and then use a SQL insert statement on that? 
 
 
 
 

First of all, Before this, it is very expensive to block Asynchronous changes and order by ordering and output ordering OD Deb SRC advance properties and changing that column's sorting property by 1. Can be easily avoided. In your TSLL Ole DB source does not automatically do this for you since the order:

Then, It will appear that the fields you are pulling are not in large size; however, if there are records of one million, then I also recommend creating a PKG which connects the data in two step-by-step tables. , Joins them, And then inserting the data as you have suggested above that this approach you use better performance.

Hope it helps.