SQL Server Performance

Update Excel sheet cells by using DTS package

Discussion in 'SQL Server DTS-Related Questions' started by kkpssomu, Jul 10, 2006.

  1. kkpssomu New Member


    Hi I have a table called tblemployeeinfo containing 5 columns in sql server. I have to compare this columns with excel sheet data, if there is any change in the data between the excel and the table, i need to update or delete the data from the excel sheet. How to achieve this using DTS package? Help please.
  2. kjp948 New Member

    First of all from this excel sheet import data to a temporary table,
    Then compare this temp table to your table 'tblemployeeinfo' .

    and if there is a change update other wise dont update.

    you can use following update statement as reference

    UPDATE titles
    SET ytd_sales = titles.ytd_sales + sales.qty
    FROM titles, sales
    WHERE titles.title_id = sales.title_id
    AND sales.ord_date = (SELECT MAX(sales.ord_date) FROM sales)

    using where clause you can compare all 5 columns if they are different or not .

Share This Page