SQL job containing a SSIS package

[Former Member]

Hi,

I'm trying to run a job that executes a SSIS package.

Some of the blocks in the SSIS package refers to files stored on network folders.

Each time i run the job manually i get an error message saying that the file can not be opened because it is already opened or because i have no permission to access it.

If i move the file to a local folder and change the SSIS package accordingly than the job runs fine.

what settings should i change in order for the job to be able to access the network folder?

Thanks, Udi

[Former Member]

Hi

Check the account which executes the job has access permission on the network folder.

thanks

Mushtaq