David Webb-CDS (5/16/2013)
Are you sure it's choking on the destination? In the advanced editor, you might want to check both the external column and the output column on the excel spreadsheet and the external column on the destination. These default to 50, IIRC, and may need to be altered if the column is larger.
OK. I've gone to the excel source and sorted it in descending order so that the top row contains the following for the offending column. (BTW this is happening for two columns actually, but I've got them both unmapped, and am tackling them separately.
Column: "Asset description" column's first record looks like this:
shop air compressor - Speedaire State of Washington pressure vessel ID = 33501-03W
shop air compressor - Speedaire State of TX pressure vessel ID = 38801-03W
I've saved this excel file and headed over to Excel Sources Advanced Editor.
First of all, I can't change the metadata for external columns on Excel source. They revert. So, I don't understand that piece of advice. Next, I do not know what '50, IIRC' is referring to. My defaults are Unicode string [DT_WSTR] 255. I am able to change only the output of Excel Source and Inputs of subsequent transforms. But data isn't leaving Excel source....