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 |
|
JeffT
Posting Yak Master
111 Posts |
 Posted - 2007-07-10 : 09:52:06
|
| Hi,I want to copy multiple tables from my prod environment to my test environment based on a specific value in one table field (example: SELECT * from Table1 where name = 'Smith') and do it in one DTS package I can reuse. I can't seem to tweak things so I can accomplish this. I can do it for one table per package but haven't been able to for multiple tables. I'd like to create this package and then run it form a batch file.Thanks,J. |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-07-10 : 12:07:43
|
| just a long shot here but why dont you do a restore from backup to a new database on your server, make all your changes you need on the newly restored database ie:SELECT * from Table1 where name = 'Smith'and whatever tables you want to delete etc, then do a backup of this database and restore it on the test server. |
 |
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2007-07-11 : 11:12:29
|
| Thanks Jim ! Actually we did a restore to a new database but we also wanted the ability to randomly copy data by specific field values (like name or any other field of our choosing) via a query in DTS to another database. So far the only way I've found to do this extracting from mulitple tables is from a batch file using multiple BCPs with "SELECTs" which seems very slow. I was hoping to extract from multiple tables using DTS, thinking it might be faster.J. |
|
|
|
|
|
|
DTS