Post reply

SSIS package working from Visual Studio but not from SQL jobs

  • October 10, 2013 at 7:19 am

    #281124

    Hi,

    I have a download script which downloads the file from the ftp and posts it on the network server.

    When i run it manually by opening the package in Visual Studio it runs fine however when i run the package from the scheduled job it runs sucessfully but the download does not happen

    Pls help

  • October 10, 2013 at 7:24 am

    #1657534

    When you run it in Visual Studio, it runs as you. When it runs as a job, it runs as the SQL Server service account, or whatever proxy is configured for the purpose.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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