When you execute a DTS package manually from a client - it looks at the
file system on the client machine. When it runs as a scheduled job, it
looks at the file system on the db server. Also, take note of the user
account you are logged onto the NT machine while running the package. That
NT user may have different mapped drives that the SQL Server Agent service
account which is the NT account running the package when it is scheduled.
Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One
"Evan Pease" <[Email Address Removed] 12:09 PM
To
"LazyDBA.com Discussion" <[Email Address Removed] schedule error
I have a DTS package which inserts a text file into one of my db tables.
The text file is generated by another system daily to:
"J:\wwwroot\Nexlink_NET\tools\componentpricer\components.txt"
When I run the DTS package from the design view, or by right clicking on
it,
it works perfectly. However, when I tried to schedule it, it would not
work.
The error message said that it could not open the text file; "Error
opening
datafile: The system cannot find the path specified."
Next, I moved the text file to F://MSQL/ and changed the DTS package
accordingly, and IT WORKED when it was scheduled.
My question is:
Why will it work from design view while it's pointing to a network drive,
but not when it's scheduled?
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
MS Sql Server LazyDBA home page