DTS Failure

[demopro]

Hello,

From my PC I use terminal manager to log into my server to make a DTS package (using the DTS wizard) that will simply output a table to a flat file (txt) and put it on another server. Sounds simple but it fails to run for the following error:

********************** ERROR MESS **********************
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Copy Data from RIC_CODE to \\Server\Dir\Folder\File.txt
Step DTSRun OnError: Copy Data from RIC_CODE to \\Server\Dir\Folder\File.txt
Step, Error = -2147217887 (80040E21)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Help file: DTSFFile.hlp
Help context: 0
Error Detail Records:
Error: 5 (5); Provider Error: 5 (5)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: Copy Data from RIC_CODE to \\Server\Dir\Folder\File.txt
Step DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.

******************************************************

I have tried changing the path to the actual physical path and to a (Mapped) drive on the server side to no avail. I have also tried both SQL and Windows authentication and still receive this error.

Help please.
Demopro

 

[mkal]

Has the folder been shared out yet. I had the same problem and it was a Windows OS permission problem not SQL.

 

[SemperFiDownUnda]

I agree it looks like a security issue. Either that share doesn't exsist or the identity the DTS package is running under does not have access to it.