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-06 : 14:02:34
|
| 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. |
|
|
|
|
|
DTS Copy multiple tables