Post reply

Data Conversion Transformation

  • July 26, 2016 at 2:23 pm

    #1892157

    Nope, there is no truncation error. A truncation error would be a violation of the input or output column definitions. The truncation is done by the defined data transformation, basically doing outputcolumn = LEFT(inputcolumn, 20). So at no time are either the input or output column lengths violated.

    Your argument that an error should be thrown in spite of the intermediate transformation that makes the value legal would be like saying the expression SQRT(ABS(x)) should throw an error for negative values of x.

  • July 26, 2016 at 3:32 pm

    #1892165

    There is a truncation error. Because by default in SSIS truncation errors fail the component.

    As shown below, without changing any other settings, taking a 100 char and converting it to length 50 char results in an error. I can choose to ignore this error but the question doesn't mention that.

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply