Merge Join transformation failing - Destination Column does not allow NULLS

  • Hi,

    I am using a MERGE JOIN SSIS transformation to join the results of 2 queries, which already contain joins in the SQL. I am expecting some NULL values from both sides of the full outer join. The destination table has default values assigned to all the columns, so the NULLS should be replaced upon delivery.

    When I rin the package, I get an error that the Value violated the integrity contraints of the target column. I DO NOT have the Keep Nulls option checked on the OLE Destination, so my understanding is that any nulls should be replaced by the default values specified in the table design.

    Anyone able to help?

    S

  • steve.burton 78514 (10/4/2012)


    Hi,

    I am using a MERGE JOIN SSIS transformation to join the results of 2 queries, which already contain joins in the SQL. I am expecting some NULL values from both sides of the full outer join. The destination table has default values assigned to all the columns, so the NULLS should be replaced upon delivery.

    When I rin the package, I get an error that the Value violated the integrity contraints of the target column. I DO NOT have the Keep Nulls option checked on the OLE Destination, so my understanding is that any nulls should be replaced by the default values specified in the table design.

    Anyone able to help?

    S

    I don't know anything about the Keep Nulls option, I don't use it. None of my warehouse tables allow nulls so I use Derived Column Transformation to check for nulls and turn them into Unknown Member appropriate to specific table/field.

    maybe not quite how you wanted to do it, but, it does work.

Viewing 2 posts - 1 through 1 (of 1 total)

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