Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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,
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900