Results 1 to 1 of 1

Thread: SSIS Script Component: Column Name as variable

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Question SSIS Script Component: Column Name as variable

    A Script Component should add a new output column (say NewCol) which is actually a copy of one of the input columns (say InpCol).
    Normally the statement to achieve that is
    Row.NewCol=Row.InpCol.
    The problem is that InpCol is not a predetermined column but can be any of the input columns depending on a user variable which contains the column name.
    Is there a way to use a variable as InpCol?
    Many thanks,
    Dinu
    Last edited by dinuA; 03-12-2006 at 05:33 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •