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