Post reply

Cannot insert nulls in oledb destination table selecting "ignore" on destination columns

  • June 10, 2016 at 11:51 am

    #311177

    i have destination table with not null columns. So in oledb destination mapping from source to destionation. i selected "ignore" and trying to insert data. The task keeps failing. Did any one faced this issue? If so what is your solution?

  • June 10, 2016 at 12:11 pm

    #1884461

    komal145 (6/10/2016)

    i have destination table with not null columns. So in oledb destination mapping from source to destionation. i selected "ignore" and trying to insert data. The task keeps failing. Did any one faced this issue? If so what is your solution?

    Not Null constraints on columns cannot be ignored. You need to do one of the following:

    1) Make sure there is data being inserted for all not null columns

    2) Change one or more of the column definitions to allow NULLs

    3) Add default constraints to the columns such that they will always be populated.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 10, 2016 at 12:12 pm

    #1884462

    You could also use a derived column to insert a default value to those columns.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 13, 2016 at 8:14 am

    #1884663

    I finally ending up doing with default values from derived column. Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

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