I want to import data from excel and update a table in sqlserver 

The excel file has a column and a pk to compare with DB table, and update db table column.

I am able to get the data using excel source and now looking for how to update the database table one column IsValid using excel (header in excel is same as header in sql table and data is also same) data. 

Excel file and db table has primary key value as ID, if the ID from excel and DB matches I want to update the table data column isValid using excels isValid field 

Is it using look up we can do it or using merge ?

​I want to import data from excel and update a table in sqlserver The excel file has a column and a pk to compare with DB table, and update db table column. I am able to get the data using excel source and now looking for how to update the database table one column IsValid using excel (header in excel is same as header in sql table and data is also same) data. Excel file and db table has primary key value as ID, if the ID from excel and DB matches I want to update the table data column isValid using excels isValid field Is it using look up we can do it or using merge ?  Read More

​