CODEWITHSUNDEEP
xmlerror-handlingssistruncation
user2931442
user2931442

Reputation: 383

In SSIS, how to ignore Truncation errors in XML source?

I have a package that contains a data flow. In the data flow, I read from XML file using XML source. I want SSIS to ignore any failure caused by data truncation. I thought that this task is simple:

1) double-click on the XML source

2) go to the Error output tab

3) select a column

4) select "Ignore Failure" in the drop-down list that corresponds to the "Truncation".

5) Click OK

However, after doing these steps and then re-opining the XML source, I find that the value I selected has been lost and the column has retained its original value in the corresponding drop-down list.

Any ideas are appreciated.

Upvotes: 1

Views: 6472

Answers (1)

Stiles
Stiles

Reputation: 11

I know this is an old post, but I was having the same problem and thought I would share what I found. You have to use the Advanced Editor to set the truncation action.

  1. Right-click the XML Source and select 'Show Advanced Editor...'
  2. Go to the 'Input and Output Properties' tab
  3. Expand the output that contains the column to ignore truncation
  4. Expand 'Output Columns'
  5. Under 'Common Properties' set 'TruncationRowDisposition' to 'RD_IgnoreFailure'

Upvotes: 1

Related Questions