SSIS

Question

Hi i have flat file that will be loaded to database with old records are coming from file will be updated and new records will be inserted to table.what components we are used Here...

---

N.suresh

Answer 1

Hey,

You can use the SQL Merge : http://www.mssqltips.com/sqlservertip/2260/sql-server-2008-merge-more-than-upsert/

or by SSIS : use DataSource that will be conected to a LookUp component (the line represent the join between the tables, and the V mark is the field to retrieve), next step will be to conect the pipeline to the 'conditional split'  and pick the routing for the relevant data .

---

Please vote as helpful or mark as answer if it helps :) Regards, David .

Answer 2

Search for upsert (update + insert):
http://www.rad.pasfu.com/index.php?/archives/46-SSIS-Upsert-With-Lookup-Transform.html

Can also be done with the standard SCD (but a bit slow if there are a lot of records)

or with a couple of lookups:

(1) check if the businesskey exists
(2) check if attributes are changed

Or with TSQL Merge like David mentioned.

tip: change the title of your question to something less general than "ssis"

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter