Post reply

SSIS Copy Column or script output - which is more efficent ?

  • May 18, 2009 at 6:53 am

    #155719

    I have the following process:

    OLE DB Source

    Script (parsing)

    OLD DB Destination (parsed data)

    I want to add a second column in the destination DB, with a copy of the original source column.

    Should this be done via SSIS Copy Column or within the script ?

    Thanks

  • May 19, 2009 at 3:35 am

    #996794

    It can be done both the ways, but since you are already using the script component to do some parsing, its better to add the new column to the script component, instead of adding another transformation.

    --Ramesh

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

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