• kenambrose (1/14/2013)


    [I am not able to use variable due to there are almost 20 data flow tasks in SSIS package and I need to use more variables.]

    Did you consider to use variable scoped to the task level? Thats what I do in ths same situation.

    How can you use a variable to switch a destination table name?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.