none
FTP task path issue

    Question

  • Hi

    I have created a SSIS package with a FTP task inside. The task uses the "Send File" feature and works in BIDS design mode.

    The problem is when I use the package inside a SQL job - each time I get this error;

    Message Executed as user: NT Service\SQLAgent$BI.
    Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit
    Copyright (C) Microsoft Corporation. All rights reserved.
    Started: 22:12:29 Error: 2013-07-02 22:12:30.11
    Code: 0xC002917B Source: PersonalFavorites_2013-06-25 FTP Task
    Description: The File "PersonalShopper_Actions_20130625.csv" doesn't contain file path(s).
    End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 22:12:29 Finished: 22:12:30 Elapsed: 0.936 seconds. The package execution failed. The step failed.

    I have set the protectionlevel to "DontSave" and I have marked the job to be ran as 32 bit.

    Thanks a lot for your help.

    BR Rasmus


    Tuesday, July 02, 2013 8:17 PM

Answers

  • What is the service account used for SQL Server Agent ? Try granting read/write permission to that account in the FTP site.

    Regards, RSingh

    • Marked as answer by RasmusEngel Wednesday, July 03, 2013 11:26 AM
    Wednesday, July 03, 2013 5:13 AM
  • Your suggestion pushed me the rigth direction, the error was cuased because the agent couldn't access the local folder where the file was which is uploaded to the FTP server,
    • Marked as answer by RasmusEngel Wednesday, July 03, 2013 11:26 AM
    Wednesday, July 03, 2013 11:26 AM

All replies

  • What is the service account used for SQL Server Agent ? Try granting read/write permission to that account in the FTP site.

    Regards, RSingh

    • Marked as answer by RasmusEngel Wednesday, July 03, 2013 11:26 AM
    Wednesday, July 03, 2013 5:13 AM
  • The FTP connection uses a dedicated username and password. I tried to change the job to use my own credentials but that doesn't change the error. BR Rasmus
    Wednesday, July 03, 2013 10:02 AM
  • Your suggestion pushed me the rigth direction, the error was cuased because the agent couldn't access the local folder where the file was which is uploaded to the FTP server,
    • Marked as answer by RasmusEngel Wednesday, July 03, 2013 11:26 AM
    Wednesday, July 03, 2013 11:26 AM