Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2009-06-18 : 09:23:18
|
| I get following errors when executing a particular SSIS under the proxy account:-------------------------------------------------------------------- The buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property. There is an incorrect file name or no permission.- The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 1 buffers were considered and 0 were locked. Either not enough memory is available to the pipeline because not enough is install.-------------------------------------------------------------------All the other SSIS packages are executing fine except this one. When I execute the package local or under my username then it works also fine. The proxy account has FULL permission on the path off the BufferTempStorage.I use Event Notification to catch errors and here I get the following error when executing the package:"profile name is not valid"The proxy account executes a stored procudure where xp_cmdshell is used to execute the package. This always worked fine until 3 days ago. We did changed some sql server configuration settings. We enabled the /PAE switch and AWE. Can this be the problem?Can someone tell me what to do to resolve this?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-18 : 16:16:40
|
Maybe your action with /PAE switch and AWE has not left enough memory for other processes to run on the server.But I really don't know.Can you try to take back your changes and see what happens?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Problem with BufferTempStoragePath