Post reply

Transformation entering spaces to please table constraints.

  • March 19, 2008 at 2:47 pm

    #69997

    Hello all,

    A green question. How can I configure a data pump transform to enter a “space” into a field to avoid tripping the table constraint of ‘not null’? I lost the epic “junk-in, junk-out” battle.

    Thanks,

    DK

  • March 19, 2008 at 3:13 pm

    #791749

    Instead of using a Copy Column transformation, use an ActiveXScript transformation. Click on the properties button of this new transformation to edit the code. Enter something similar to the following:

    If IsNull(DTSSource("Col001")) Then

    DTSDestination("Name of Destination column") = " "

    Else

    DTSDestination("Name of Destination column") = DTSSource("Col001")

    End If

    Main = DTSTransformStat_OK

  • March 20, 2008 at 11:22 am

    #792151

    Thanks for the quick reply Erik, That did the trick!

    Thanks again,

    DK

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

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