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

BufferTempStoragePath Expand / Collapse
Author
Message
Posted Sunday, November 30, 2008 10:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 12, 2014 11:01 PM
Points: 33, Visits: 58
Hi All,

I have ETL jobs running on one of our server. Jobs are scheduled to run early morning.....Jobs run fine.. but sometimes it comes up with following error....

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.

I have no idea what this error means...I had look into MSDN support site, not much help either..

any thoughts will much appreciated...

thanks..

Post #611028
Posted Monday, December 1, 2008 3:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, January 5, 2014 10:56 AM
Points: 22, Visits: 153
BufferTempStoragePath is the file system path used to temporarily cache buffer data.

As you say, sometimes it happen means the the problem is not permission.

I think that you have a problem with storage.

check if there is enough space on disk.

Post #611122
Posted Monday, December 1, 2008 2:01 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 12, 2014 11:01 PM
Points: 33, Visits: 58
hi shmuel_v

Thanks for the reply...I thought the same, but have enough space in server ..Disk size - 205GB (Used :60GB and Free: 143GB)....
Post #611673
Posted Monday, March 9, 2009 10:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 17, 2012 8:58 AM
Points: 1, Visits: 25
Hi, I'm facing the same issue...
Post #671706
Posted Tuesday, September 8, 2009 8:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 7:17 AM
Points: 51, Visits: 167
BufferTempStoragePath is only used when SSIS needs to page out, meaning it is low on memory and needs swap space.

It is true that you may be having a permissions issue and not a hard disk issue.
Post #784312
Posted Friday, April 12, 2013 1:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 12:35 PM
Points: 1, Visits: 87
Agreed. Ensure the service account running the SSIS package has permissions on the location. If there is no location specified,the default: users name, temp directory.

You may want to specify a local fast disk as the BufferTempStoragePath to prevent the issue (give it perms) and to optimize performance.
Post #1441908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse