How to update the Excel sheet data into the SQL table Using SSIS

• MSKR

  SSC-Addicted

  Points: 492

  More actions

  July 31, 2009 at 9:00 am

  #134352

  Hi

  I have a excel file with 3 sheets(Sheet1,Sheet2,Sheet3).Sheet1 contains basic data like dimension values like (ProductName,ProcuctType,Month) that i can load directly into the Table. Now coming to Sheet2 contains some Fact data and i need to update that fact data fileds into the same table based on ProductName,ProcuctType,Month and Sheet3 also contain some more fact data and that also need to be updated into the same table based on ProductName,ProcuctType,Month

  Overall here we need one INSERT query and 2 Update Queries based on some contion

  so can any one help regarding how to proceed with this requirement??

  Thanks in advance

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  July 31, 2009 at 9:30 am

  #1033021

  you need to create stage tables in sql database only, and first populate the data in those tables and then finallly load it in excel sheet.

• gawasshree

  Newbie

  Points: 5

  More actions

  July 18, 2014 at 7:08 am

  #1730587

  Hi,

  Here the question is to update data in the table from excel.

  After creating stage tables , how to update that data into main table. Can you answer more briefly with query.