Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Question Unanswered: DTS not running on a mapped drive

    I created a DTS local package on the SQL Server. It's basically importing a text file into a table in my database. This file resides in a mapped drive (X from another server. When I schedule the DTS as a job, it fails. It doesn't execute any of the workflow in the design.

    However, when I copy the text file into a drive local to the SQL server (D, it runs flawlessly.

    What I do right now is I have a windows scheduled task that runs a batch file that copies the text file from X: to D: at certain time intervals. Then the job scheduler runs to import it.

    What am I missing? How come the job scheduler can't read the file directly from the mapped drive?

    Any info would be appreciated. TIA

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by ARPRINCE

    What am I missing? How come the job scheduler can't read the file directly from the mapped drive?

    Any info would be appreciated. TIA
    A mapped drive only exists in the context of your login session. You will need to use a UNC path to reference the file:

    \\MyServer\ServerShare\Path\FileName.txt


    Alternatively (NOT recommended), you can use the command NET USE, but you are much better off using UNC.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Thumbs up

    Thanks - that worked for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •