Kindly find attached a screenshot of my configuration

hi,

Thank you for your help,

I'm facing a problem with bcp to add double quote for each nonnumeric filed, and I prefer the SSIS Which is more professional and usefull...

due to the Conflict of ideas, I just notice that I need the endDate to be used for removed destination or prefix

Example:

INSERT INTO @Tariffs(Tariff_id,Prefix,destination_name,rate,startdate)

SELECT '127','3360042','France-Bouygues Mobile','0.15','2010-05-22' UNION ALL

--Rate changes

SELECT '127','3360042','France-Bouygues...

This is very helpful,

I want to clarify that the endDate does not exist in the Excel offer, I'm using a stored procedure that modify the endDate for the previous offer...

Dear Lowell,

this an example from the current scenario:

offer 1:

Tariff_idPrefixDestination rate startdate endDate

1273360042France-Bouygues Mobile0.xxx2010-05-222079-01-01

offer 2:

I got...