Post reply

SSIS - Script Component

  • May 1, 2006 at 12:22 pm

    #113085

    I have a Table A that needs to be transformed to Table B through SSIS 2005 transformation script component. I'm able to reference the input columns in VSA code but I'm not able to reference the output columns for OLE DB destination object. Keeping in mind that it is a synchronous transformation.

  • May 3, 2006 at 11:17 am

    #635723

    Synchronous components use the same buffer for input as for output. Therefore, any reference to input columns is also referencing output columns.

    Any new columns that you add to the script component are still part of the input buffer (a little bit confusing that one) so you can still reference them with "Row." notation.

    HTH

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

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

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