Post reply

BufferTempStoragePath

  • November 30, 2008 at 10:32 pm

    #196746

    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..

  • December 1, 2008 at 3:39 am

    #905441

    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.

  • December 1, 2008 at 2:01 pm

    #905918

    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)....

  • March 9, 2009 at 10:20 am

    #956177

    Hi, I'm facing the same issue...

  • September 8, 2009 at 8:50 am

    #1050567

    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.

  • April 12, 2013 at 1:54 pm

    #1606146

    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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply