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:35 am

    #1591094

    Mackers (2/26/2013)

    Just out of interest, how would that work if you wanted to change the database name?

    Mack

    Which database name?

    Obviously, the stored proc has to live in a known location and if both the source and target database are completely dynamic, it would have to go into a separate database completely, which is known. Then it could accept parameters - source & target database and table info - and generate and execute dynamic SQL to perform the update.

    But it's difficult to judge whether that level of dynamism is required, without more info from the poster.

    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.