Home Forums Data Warehousing Integration Services Use a variable to dynamically specify the table name RE: Use a variable to dynamically specify the table name

  • February 26, 2013 at 3:26 am

    #1591091

    Mackers (2/26/2013)

    The only ways I can think of doing this are by generating & running dynamic SQL statements either through a stored proc (passing the table names as variables) or a task script (again passing the table names as variables)

    Mack

    Or write all of the update logic in a single stored proc which encapsulates the cross-database logic and just call that - nothing dynamic required.