DTS Scheduled Job with Mapped Drive fails 1

[mkell1]

I'm hoping that someone can help me out. I have a DTS package that runs fine as a package but fails once scheduled. The package uses a Transform Data Task to move data from a table into a text file on a mapped drive. The drive is mapped as the U: Drive. When I manually run the package, it executes perfectly, creating the text file in the appropriate path on the U: drive. However, when I schedule the job, it fails. When looking at the task history, the step gives the following error:

Executed as user: PMSI\SQLServer. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 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.


I have mapped the drive while logged in as the SQLServer user ID. Does anyone have any suggestions as to what can be done to get this job up and running as a scheduled job?

Thanks!

Melissa

 

[mkell1]

Problem solved by referring to the full server and path name rather than the mapped drive.

sorry for the post.

 

[JayKusch]

Correct ... SQL Server does not recognize mapped drives.

Thanks

J. Kusch