dts packages error permission denied to access shared path

Posted on 2009-05-22
Medium Priority
Last Modified: 2012-05-07
I have some issue with my dts packages with permission denied to access and copy the file to diff folder.

Here is the error msg

Step Error Source: Microsoft Data Transformation Services (DTS) Package  
Step Error Description:Error Code: 0  Error Source= Microsoft VBScript runtime error  
Error Description: Permission denied    Error on Line 9    Step Error code: 800403FE  Step Error Help File:sqldts80.hlp  
Step Error Help Context ID:4500  

File ID:        \\Flex3376TY\Temp$\Phpone\improptu.xls    

here is the Vbscripts

'  Visual Basic ActiveX Script

Function Main()

      Dim l_objFSO, l_objFile
      dim l_objPackage
      set l_objPackage = DTSGlobalVariables.parent
         Set l_objFSO = CreateObject("Scripting.FileSystemObject")
      Set  l_objFile = l_objFSO.GetFile(DTSGlobalVariables("g_strCurrentFilePath").Value)
      l_objFile.Move DTSGlobalVariables("g_strErrorFileFolder").Value & l_objFile.name & DTSGlobalVariables("DTSLineage_Short").Value
      set l_objFSO = nothing
      set l_objFile=nothing
      set l_objPackage = nothing
      Main = DTSTaskExecResult_Success

End Function

Hpw do I know whether it managed to access the path or not?
Question by:motioneye
  • 2
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24451342
The account used to run the DTS package does not have access to that folder.

Author Comment

ID: 24453688
How do I know which account use to run the dts packages? I seems couldn't find this such info.
LVL 75

Accepted Solution

Anthony Perkins earned 2000 total points
ID: 24456082
What executes the DTS Package?  If the answer is that it is scheduled using SQL Server Agent then check the startup account used by the SQL Server Agent service.  If you are executing it manually or through an app, then look for the Windows account that is logged in.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question