locked
Script task using in SSIS to delete database table row matching record with excel source RRS feed

  • Question

  • Hi All,

    i have one excel source and one destination table in oracle data base.  i need to design one ETL package in SSIS in that i have to delete data from table if data is matching with excel data column. 

    Excel Source                                  

    DATE ----------NAME---------ID

    20100123--   AAA    ------- 01

    20140330-- BBB    -------- 02 

    and like same table  we have in database too. when ever below condition will match data has to delete from table.

    Delete from table_ABC where table_date=date(excel sheet date column).

    how to implement this using script task in ssis , please provide c# or Vb code also if possible. Thanks!!

    Regards,

    Akhil

    Tuesday, December 23, 2014 5:08 AM