Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Script task to change table name in data flow task RE: SSIS Script task to change table name in data flow task

  • January 14, 2013 at 9:09 am

    #1576950

    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?