temp folder for SSIS job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » temp folder for SSIS job

temp folder for SSIS job

Rate Topic

Display Mode

Topic Options

Author

Message

sudhirnune

Posted Monday, September 17, 2012 6:54 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, June 09, 2013 9:52 AM
Points: 81, Visits: 195

Hi All,

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.

Post #1360169

« Prev Topic | Next Topic »

Permissions