In a new ssis 2016 server package, I am trying to update a sql server 2016 table with data from an excel 97-2003 spreadsheet. I keep getting an erro on a column called zipcode. This column most of the time has the values that look like 68101-1234. However there are times when the value looks like 68111. Basically the data lengths are different. The format of the exce data column is called 'General'. The format of the sql server column is: [ZIPCODE] varchar NULL Would you tell me what you suggest I do to make the ssis package work.
What is the error you are getting?