SQL Server Performance

Script Component

Discussion in 'SQL Server 2008 Integration Services' started by SQL_Learner, Oct 3, 2012.

  1. SQL_Learner New Member

    Hi.
    I want to make an output based on a one of my source fields.
    Sample:
    IF F1 = 'AAA' (In Source)
    return output = 1

    F2 = output (In Destination)

    I think the best way is use Script Component to get input and change to my favourite output.
    I've attached my project's picture.
    Thank you.

    Attached Files:

Share This Page