BLObs in SSIS – Part 2 – The BLOb-Load Turbo Button.

As we saw in the first post in this series – BLObs in SSIS – Part 1 – How Does SSIS Load BLObs? – SSIS copies BLObs from their source to the location stored in the TEMP and TMP operation system environment variables. That location defaults to %USERPROFILE%\AppData\Local\Temp. That’s a problem because that default location …
Continue reading BLObs in SSIS – Part 2 – The BLOb-Load Turbo Button.

BLObs in SSIS – Part 1 – How Does SSIS Load BLObs?

How Does SSIS Load BLObs? When SSIS loads Binary Large Objects (BLObs), the Data Flow Task first copies the data from the BLOb storage location to some location and stores the BLOb in a file. When it’s time to write the BLOb value, the Data Flow Task reads the BLOb from the file location and …
Continue reading BLObs in SSIS – Part 1 – How Does SSIS Load BLObs?