Wednesday, September 21, 2011

SSIS TempStoragePath Error

[DTS.Pipeline] Error: The buffer manager cannot create a file to spool a long object on the directories named in the BLOBTempStoragePath property. Either an incorrect file name was provided, or there are no permissions.

This error usually occurs when BLOBTempStoragePath and BufferTempStoragePath properties(on Data Flow Task) refer to an invalid location. Verify that these folders exist under the path specified in the properties.

No comments:

Post a Comment