July 23, 2018 at 3:43 pm
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](10) NULL Would you tell me what you suggest I do to make the ssis package work.
July 23, 2018 at 7:05 pm
wendy elizabeth - Monday, July 23, 2018 3:43 PMIn 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](10) NULL Would you tell me what you suggest I do to make the ssis package work.
My guess is that the Excel driver is presenting the values containing a hyphen as string and the others as INTs. This is a common problem with Excel and a total pain. Your easiest solution is to export from Excel to CSV and then import from CSV.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply