>>How doe SSIS select the data type for excel columns and how can I override it.
>>
>>Thanks
>
>Nick, over the years I've been frustrated with the way that SSIS works with Excel. So if I'm able to convert the spreadsheet to a CSV file without any loss in functionality, I'll do so.
>
>Naomi's post might very well help - the IMEX property can be of great use - but I always try to use CSV where possible.


Thanks Kevin


I'd found a link about the IMEX property and it seems to solve my problem.


BTW this code seems to resolve the NULL filling in part of my previous issue with this data

declare @Case_ID nvarchar(255);

UPDATE [dbo].[Complaints]
SET
@Case_ID = COALESCE([Case ID],@Case_ID),
[Case ID] = COALESCE([Case ID], @Case_ID)


Nick