Thursday, 19 September 2013

Importing CSV to SQL Server with text column > 8000 characters

Importing CSV to SQL Server with text column > 8000 characters

I'm trying to import a csv file with two columns (sku, description) into
SQL Server 2008 using the SQL Server management studio 2012 import/export
wizard. Because the description column definitely has rows greater than
8000 characters, I go to the advanced tab when choosing the csv data
source and click on the description column and click "Suggest Types". It
then puts in 16718 for the OutPutColumnWidth property. Apparently there is
a description in there somewhere that is THAT long.
The sql it generates is:
CREATE TABLE [dbo].[mag-prod-descriptions1] (
[sku] varchar(7),
[descrip] varchar(16718)
)
However, when I execute the import, I get the error "Could not connect
source component. Error 0xc0204016: SSIS.Pipeline: The "Source -
mag-prod-descriptions1_csv.Outputs[Flat File Source Output].Columns[Column
1]" has a length that is not valid. The length must be between 0 and
8000."
If I change the OutputColumnWidth property to 8000 then I get an error
saying the column was truncated. I can't win.
How do I get the thing to allow me to import cells that are greater than
8000 characters?

No comments:

Post a Comment