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 5:11 am

    #1576842

    Phil Parkin (1/14/2013)

    Do your various destination tables contain different column definitions, or do they all have exactly the same structure?

    Table structure is same - columns, data types are same.

    For example: TableA & TableAa has same structures (columns, data types are same). TableA needs to replace with TableAa, same way TableB needs to replace with TableBb.

    Thanks