May 16, 2007 at 1:29 pm
I am attempting via scheduled DTS package to move a text file from one server to another. Our SQL Server is set up on a central box lets call it Server X which is only mapped to itself therefore when exporting data in a text file for example it must be done on the same server.
I recently set up LOCAL server on my desk top and as I understand things automated jobs run on the LOCAL server as opposed to our central location i.e. server X. I have created a DTS package which takes a copy of a text file from one server and places it on another server -- when run manually this package works fine -- when it is scheduled I get an error (to summarize) that the path cannot be found -- full error below.
Executed as user: EUSC004665\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Help Please...
May 16, 2007 at 1:57 pm
...80004005 ... when EUSC004665\SYSTEM runs the package it has no access to the file you've specified. Provide EUSC004665\SYSTEM the authority to go to the folder where you've put the file.. If it is a mapped drive, use UNC in stead. \\yourserver\yourshare\...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 16, 2007 at 2:06 pm
Hi Alzdba,
When you say use UNC in stead if it is mapped can you explain a little more. Do you mean preface the mapping location with UNC i.e. \\UNC\myserver\myshare\...?
May 17, 2007 at 2:10 pm
if i m correct unc means uniform naming convetion. i.e. the fully qualified name (servername.domainname.extention) and a path on that server.
e.g \\yourserver.yourdomain.com\yourshare\...
If the serviceaccount has been granted the right to read the files, it will work.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply