We have a issue with respect to the temp Space for the SSIS Job Execution.
When the Proxy User is provided access to C:\Users - WIND 2008, the Data Load Works Very Well.
If the User does not have Access to C:\Users and only to his Folder the Job Fails saying Un-Authorized.
Please need help to understand what is the process for the SSIS to Pick the File and Store during the process.
I tried updating the Buffer Size & Blob Size Variable to C:\Temp, but not really working.
Please need help ti Understand the Underlying process of Data Flow from the File Picked from the Source to the Data Extraction from the File.