Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

temp folder for SSIS job Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 6:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
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 »

Add to briefcase

Permissions Expand / Collapse