I want to send that table in HTML format to my email id

Dear both, in simple I want to append SQL table thru import/export wizard (from excel file) and that table having only tow column,

1) Customer Account No (Primary key/unique no.)

2) Sales...

Dear expert, thanks for reply

I solved first error and but could not understand error in second code

could you please provide more or correct code, I am not much expert in...

Ok , then what will the solution if I created unique key

I will join "Year&Month&CustomerNo." and generate unique key

ok, what will be the way if I created unique key in my data ?

I will join "Year&Month&CustomerAccount" and create unique key

then what will be the solution

Dear Phil Parkin

yes, that's why I created table and have separate Year and Month column in my excel/sql table

please give way

Is there a unique key in the source Excel data?

It seems that your ideal flow would be something like:

1) Process Excel file. For each row:

2) Does row exist in target...

if you remove the DELETE functionality from your ssis package, data will be appended in your table without any issue.

Dear Sir, thanks for reply

but if i remove delete function then...