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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2003-11-12 : 07:00:23
|
| hello,is it possible to use DTS to copy an MDB from a mapped network driveto another server ?I have a file data.mdb on server1I need to copy the file on a daily basis to server2.I have tried using the import wizard but theres no option to copy files.thnaks for any info.Jamie |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-12 : 08:11:31
|
| You don't need to use DTS for this at all. Create a regular job and add a single CmdExec step. In the command window, enter:copy myFile.mdb i:\myFile.mdbYou can schedule that job to run automatically or run it manually when needed, or both. See the Windows help file for more info on the copy command. Be aware of network rights to the local hard drives and network drives when automating this. The account that runs SQL Agent must have enough rights to the network drive. Also consider using UNC paths instead of mapped drive letters, since mapped drives are not always the same for all accounts. |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2003-11-12 : 08:16:41
|
| lovely stuff Rob !!cheers. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-11-12 : 11:42:16
|
| If it's very big, also look at robocopy. It's significantly faster than copy and has more option.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Copy file from one server to another