When I run the package in debug mode using Visual studio, it works fine, no errors.

When I run it in a scheduled job in SQL Agent using a service account I get this error. I wrapped my code in the script task in a try catch block and I get "Access to the path ... denied", the error message is copied below. I have set everyone full control on the files and folders on E drive.

Error Message:

Executed as user: MyDomain\MyServiceAcct . Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 7:36:00 AM Error: 2013-11-20 07:36:04.36 Code: 0x00000000 Source: Set FSFileParameters Script Task My File Task Description: Access to the path '\\MyServer\E$\MyFiles\FSP\' is denied. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:36:00 AM Finished: 7:36:04 AM Elapsed: 3.588 seconds. The package execution failed. The step failed.