CODEWITHSUNDEEP
sql-server-2005ssis
Jim Evans
Jim Evans

Reputation: 6505

SSIS 2005 problems importing to nvarchar(max)

I have some XML files that I do a weekly import from for one of our systems. Four of the pieces of data in the XML range from 450 to 650 characters in length. I have tried everything I can think of but they always get truncated at around 255 characters. I tried setting the landing column to nvarchar(max), varchar(max), varchar(1000) and varchar(600) and none of this worked and I still get the same truncation. I inspected the XML files and the data there looks good. All the rest of the data comes in without truncation - just these four items have issues. I did find out googling around that SSIS considers nvarchar(max) and varchar(max) blob fields so I assume that is why they do not work correctly - but the others ??

Upvotes: 0

Views: 892

Answers (1)

Ann L.
Ann L.

Reputation: 13965

Within your Dataflow screen:

  1. Look at your XML Source object. Right click on it and select Advanced Editor.

  2. Go to the Input and Output Properties tab

  3. Expand the nodes until you see folders labeled External Columns and Output Columns.

  4. Expand those. You will probably find the 255 char length set in those.

Upvotes: 3

Related Questions