Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rosgood52
Starting Member
5 Posts |
 Posted - 2009-03-25 : 10:39:01
|
| Hi all,I have searched these plus many other forums looking for a solution. Here is what I am trying to do:I have a database with approx 200 rate tables that are updated frequently. The updated tables are validated and then must be replicated to 7 other databases (dev, QA, UA). I was originally hoping to use a simple XML file with the table names. I would loop shred the XML file, load the table name into a variable and then have a simple execute SQL task truncate the destination and reload the table from the updated source table.I am finding this to be less than easy. Table names cannot be used as parameters in this version and using dynamic sql is open to injection. Has anyone done this and if so would you be willing to provide a sample of your package?Thanks |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-25 : 10:51:34
|
| why don't you use embedded replication?Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
rosgood52
Starting Member
5 Posts |
Posted - 2009-03-25 : 15:34:42
|
| Thanks for the suggestion. I will look into that. |
|
|
|
|
|
|
Loop through tables scenario - SQL 2005