Using UNC (or Mapped) Drive Pathing with DTS

#11

Hi MTS,
Related question:
I have a Flat file connection pointing to a Mapped network drive (let see
S:\myfile.txt). Package is running fine.
Now I replaced S: by the UNC in the file pathname
(let see \\fdd\web - sadd\text files\myfile.txt) but the package can not
find the file at run time.
By the way, Flat file connection ConnectionString Property is populated
using a Variable. Any suggestion ?

"mts" wrote:

Quote:

Scott,

Thanks for taking the time to answer. I thought that I was running this
under the auspices of the domain account and checked to be sure (I was not
the person who set up the server service or the agent service) and I am. But
things get wierd at this point...

I also re-checked my DTS and found that my target was still pointing to
"mapped" drive pathing instead of UNC; changed that; and now it works. I
know that it did not before and confirmed this with the other DBA here in the
office.

Anyway, thanks for taking the time to answer.

MTS.

"Wm. Scott Miller" wrote:

In order to get access to network shares/locations, you must be running
under an account that has network access. Normal setup for SQL Server has
the server and agent running under local system which doesn't have network
access. That and you should never be running SQL Server or agent as local
system because of security concerns.

Scott

"mts" <mts (AT) discussions (DOT) microsoft.com> wrote in message
news:F072E0D3-54DF-40D0-A782-2FD12BFD984C (AT) microsoft (DOT) com...
I run several DTS packages each day, I would like to convert from an e-mail
based export system where I save the exported file locally to the server,
then pick it up as an attachment and email it to a system where I export
the
data file to a network share location.

The issue I am having is that my SQL Server can't (or is unwilling) to see
the network locations because it is not logged in. While that makes
sense, I
am also unable to utilize UNC pathing. Either way I get the same error
message when the job attempts to execute:

Executed as user: CUP\SqlAdmin. DTSRun: Loading... DTSRun:
Executing...
... 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.

Is there a way around this?

Thanks,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using UNC (or Mapped) Drive Pathing with DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Using UNC (or Mapped) Drive Pathing with DTS - 04-03-2008 , 09:47 AM