String over 255 characters

[charlize]

Hello,

I get an XML file with a field that contains over 255 characters. I use a XSD file to import the data in to a SQL table. The XSD file uses the data type string, but then the field is truncated to 255. How can I avoid this?

Charlize

 

[Diancecht]

XSD is used to define an schema, to validate a document but ... how are you using the XSD to load the file to the DB?

Are you sure there ins't anything else?

I don't think the 256 bytes restricion by default.

Cheers,
Dian

 

[charlize]

I use a SSIS package. Just now, I saw at the advanced editor, that the field has a length of 255. I have changed it and now it works fine. But why is it set to 255 when the field contains more than 255 characters?

Charlize

 

[Diancecht]

I know nothing about SSIS, but I guess it tries to make it fit on its specification.

Cheers,
Dian

 

[harebrain]

It's the SSIS default for varchar datatype. (The "Wizards" don't ask many questions, they just make a lot of assumptions.) Either fix the SSIS package, or create your result table ahead of time with column sizes that are closer to what you want.