Post reply

Using a constant value to populate a destination column

  • October 10, 2008 at 1:07 am

    #123934

    I want to populate one of my destination columns using some constant value. Say, I want to populate myDestTable.IntColumn with "1". The Mappings tab in the edit OleDbDestination window only allows me to "Select" some input columns. Is there any way I can enter a hardcoded value there, or I have to add my constant-valued column to my input source using CopyColumn/DerivedColumn transformation.

    Also, I want to use one input column to populat multiple output columns. That is, I want to fill myDestTable.Column1 and myDestTable.Column2 with mySrcTable.ColumnX. As soon as I map myDestTable.Column1 with mySrcTable.ColumnX, it desappears from the available input columns list. Is there any way to achieve this or I have to use some transformations here again?

    Regards,

    Syed Mehroz Alam

    Syed Mehroz Alam
    MyBlog | MyArticles

  • October 14, 2008 at 7:41 am

    #884620

    You'll need a derived column for any constant values and you can only map one input column to one output column in the destination so you'll need to do a copy column to use the same input column for multiple output columns.

  • October 14, 2008 at 9:54 am

    #884726

    Thanks for your reply Chris, I was already using the derived column transformation and was trying to find if there is any other solution.

    Have a nice day.

    Regards,

    Syed Mehroz Alam
    MyBlog | MyArticles

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

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