Hi,
try to say it short...
Works fine when run in SSIS
1. The user account that runs the SqlAgent does not have access to the network folder where the CSV files reside
2. My win account does have the necessary rights
3. I created Credentials identified by my account information
4. I created Proxy configurations for 'SSIS Package Execution' for the credential name I created above
5. In the JOB Step I pick the proxy created above to the 'Run as:'
The JOB starts OK but fails:
'Code: 0xC020200E Source: ZACC_POS4 Description: Cannot open the datafile'
(I found one hint in the web where someone solved this by creating a local(!) user account in the remote server with the sam name as the account that runs the SqlAgent...but I don't understand this at all and further more it is a real pain to get anything done via the third party that hosts the server anyway...)
What is missing in my solution?
Any help appreciated, Ville