Hi I have data in XL sheet, i need to load the data to data warehouse and we need to update the data everyday in data warehouse . i mean getting new data everyday from XL sheet, if it is new data, have to insert that. if it is old data have to update.. what are the transformations for this scenario Could you please tell me guys Thank you

Load the data from Excel to a staging table, from there please see if this post is of help to you: Get all from Table A that isn't in Table B http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx Arthur My Blog

If there not to many data in the Excel-Sheet you can use a Slowly Changing Dimension Task. If it's more than 10.000 rows it's better toload the data into a staging table. Write a Stored Procedure to delete the existing data and load all new into destination or use merge (SQL 2008 and higher) or write update and insert statements.

You should read the FAQ. There's an entry in there for "inserting if new, updating if it exists" that you should read. Talk to me now on