Post reply

SQL Server Agent access to folders

  • April 14, 2003 at 8:49 am

    #159844

    I have a DTS package that runs the FTP task.

    The package executes fine on its own but when I run it from I job I get the following message.

    DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnError: DTSStep_DTSFTPTask_1, Error = -2147220489 (800403F7) Error string: Folder \\St-info\Cordelia\MarkBData\CaMIS output\Outpatient MDS\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: Folder \\St-info\Cordelia\MarkBData\CaMIS output\Outpatient MDS\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

    I am not sure if this is becuase there is incorrect permissions to the folder. Can I grant the agent access to the this folder in anyway or is there some other way that I need to set the job up?

    Any help is much appreciated

  • April 14, 2003 at 9:12 am

    #454079

    Your SQL Server Agent service account has to be a domain user account with proper access permission to folder \\St-info\Cordelia\MarkBData\CaMIS output\Outpatient MDS\ and make sure folder exists.

  • April 14, 2003 at 9:41 am

    #454087

    Allen,

    Thanks for the reponse.

    Without wanting to sound too dim what is the best way to do this? I have had a quick look at the SQL Server agent settings on the machine but I don't know that much about it.

    The account that it is using is the system account. Is there anyway of simply identifying the sql account and granting this access to the relevant folders. The folder that I trying to write to is on the same server as the sql that it trying to write to it, if that help?

    Thanks

  • April 14, 2003 at 10:00 am

    #454092

    You don't have to change the service account as the folder is in same server as SQL Server. Just find that folder --> property --> security --> permission --> make sure "SYSTEM" has proper permissions to read/write or full control to it.

  • May 2, 2003 at 9:21 am

    #456018

    Thanks Allen

    Have managed to get the system account to access the folders that it requires to copy the information.

    Your help is much appreciated!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply