Making rules to import excel file to sql table in SSIS

See more:

SSIS

Hi all,

I have created a package in which I have created a data flow task to import excel file with 3 columns Year, Month and Data to an sql table.

But now i need to make some rules for import.

If the year in excel file and in the table is same, i only need to refresh the column 'Data' in the sql table. But if the year is different, then i should append new rows for Year, Month and Data to sql table.

If the year is same, then I should check if the month is same in both excel and table, if they are same i need to refresh the column 'Data' in table . Else, I should append the new rows for Year, Month and Data.

Please give me some idea to execute this task.

Thanks in advance,