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 |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2009-08-24 : 10:08:25
|
| I've tried to search for information about this but I'm at a lost. Here is my scenario:1. I have a table that I truncate and repopulate on a monthly basis.2. I used the DTS wizard to copy the information from Access to SQL.2a. The first DTS clears out my table and copies the first office data.2b. I have 3 more DTS packages that appends to my SQL table but are 3 different offices.Here is what I'd like to do: create one DTS package that will do the following:1. Open the SQL table and clear all data.2. Open my Access database and copy the first office data.3. Close this database and open the next office database. Rinse and repeat until all offices I need are copied. |
|
|
|
|
|
Schedule one job for multiple DTS