These both properties are on the data flow task.
They define where on the hard disk(s) to page buffer data to. BLOBs (text, next, image) are written to BLOBTempStoragePath. All other buffer data will be swapped to Buffertempstoragepath.
This is useful when C drive has less storage. When BLOBTempStoragePath is not set, the paths as defined by the system variables TEMP and TMP will be used. The same rule applies to Buffertempstoragepath.
For better performance, we recommend both BLOBTempStoragePath and Buffertempstoragepath point to fast drives. We also suggest that the drives for Buffertempstoragepath and BLOBTempStoragePath be on separate spindles in order to maximize I/O throughput.
No comments:
Post a Comment
If you have any doubt, please let me know.