My Job fails due to script task.This script task check if file exists in a folder or not. If not it will not go to next control. Manually it is running good. But if i run a job it fails because its not stopping on script task it continuous to run (going to next task which is extracting data from that file). How to fix this
Where is the file located in relation to the server running the job.
The File is in different server. My package is running in different server
What user is running the package?
What account is integration services running as?
That user need permission to that folder
its a proxy account. And i have access to those files.
You have access but does the proxy have access to them?
I have redeployed the package using different procedure. Its working now