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
November 18th, 2012 8:07am

Hey, You can use the SQL Merge : 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 .
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2012 8:28am

Search for upsert (update + insert): 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: | Twitter
November 18th, 2012 9:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics