LOCAL server mapping

  • 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...

  • ...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

  • 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\...?

     

  • 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