September 14, 2011 at 5:22 pm
Could anyone shed any light on how SSIS determines where to put temp files?
Using SSIS 2008 R2, running on Server 2008 R2 64bit
I'm reading data from excel files using Excel OLEDB (package is running in cmd shell using the 32 bit dtexec.exe since it can't run in 64 bit mode and is called from another package)
I was getting failures on the test server due to access denied to the following locations:
C:\windows\temp
C:\users\Public
C:\Users\Default\AppData\Local
gave modify rights on each of these locations to my proxy account and the job ran fine.
I discovered this by using Process Monitor and looking for Access Denied results. (this tool has been a life saver by the way)
So today I go to deploy to production, gave these locations access and got failures due to access denied in subfolders of the AppData directory for the profile that is running the SSIS service (the service account, not the proxy account).
Again I go in a give the access needed, since this is the only thing I can do. I don't have a clue how the directory is determined and if there is a way to control this.
Now this may not be controlled by SSIS at all, this could be a secondary process such as a windows process that is referencing these locations but the security all falls under my SSIS proxy account.
I've run into this before when referencing a DLL within a script component. I don't believer this is a data buffer temp file either.
Any thoughts would be appreciated - thanks
September 14, 2011 at 11:00 pm
not too sure but two tihngs in my mind which might help,
1) go to option--add-in/Macros Security in SSIS project window.
2) go to component services--dcom config--open properties window of msdtsserver/msdtsserver100--security tab. and configure the settings accordingly
----------
Ashish
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply