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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-17 : 07:48:21
|
| Derek writes "We have created a DTS package that brings in data from another database to our SQL Server database. It contains a mapped network drive such as "Z:\file information" to refer to the file that the database being exported is in.The package executes successfully when run manually because the user has a mapped network drive to I. However, when we schedule the task to run as a job, it does not appear to be recognizing the network drive. We have tried adding a NET USE Z:\\.... command as step 1 of the job and are still unsuccesful. Can you offer any advice?We are using Windows 2000 Advanced Server, and are current on all of our service packs. We are running SQL Server 2000, sp2 with patches added for the slammer virus, etc." |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2003-04-17 : 08:09:43
|
| When running the DTS Package through a scheduled package, the package in run in the context of the account that is used to start the SQL Server Service. If this account does not have permissions on the Networked drive, then the package will not execute correctly.This is where I would start on trying to figure out the problem.Jeremy |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-17 : 09:24:11
|
| I always thought that when a DTS package is executed manually, then the drive mappings of the local client were used. If scheduled then the mappings of the server are used.That's when I set up a mirrored environemet on my client to match the server ( I also set up sych points through scheduler to copy file to make sure I have a complete mirror).Maybe I'm wrong (lord knows it won't be the first time), but that's what's worked for me/us.Also, with ALL of the headaches with DTS, I'll never use it in a production environment....fine for moving excel/acess/ect quickly to do analysis, but to set up a transfer of data, I'd use bcp or bulk insert.Good LuckBrett8-) |
|
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2003-04-17 : 11:01:03
|
| I agree Brett. I have had so many problems getting DTS to work through scheduled jobs, or from a SP that I gave up.Microsoft offers a Knowledge Base Article on this. [url]http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b269074[/url]Hope this helps.Jeremy |
|
|
|
|
|
|
|
|
Automating a DTS Package - network drive issue