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

MS Sql Server LazyDBA home page