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 |
|
rpatel18
Starting Member
9 Posts |
 Posted - 2007-07-02 : 10:41:48
|
| I'm trying to import multiple mdb files(6 files with multiple tables inside) all at once but can't seem to figure out how to do this. I'm reading about DTS but dont think I quite get it yet, do I have to create a task for each individual table? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 11:50:45
|
| You can have multiple tasks in single dts package. |
 |
|
|
rpatel18
Starting Member
9 Posts |
Posted - 2007-07-02 : 12:03:05
|
| yeah but me creating 120 tasks(20 tables in each mdb) would take quite some time. |
|
|
|
|
|
|
batch import of mdb's?