Requirements

Installation

GDAL environmental variables

Making SSIS 2008 components available in BIDS

Follow these steps to add GDAL SSIS components to the toolbox in your integration services project.

  1. Open your integration services project.
  2. Right click anywhere on the toolbox.
  3. Select Choose Items.
  4. Browse to the SSIS Data Flow Items tab and select the GDAL SSIS custom components.

Considerations for 64bit environments

GDAL SSIS components are designed to run in 32bit mode.   If you are using GDAL SSIS on a 64bit machine you need to make some adjustments.

Performance considerations

GDAL SSIS data flow buffers can become large when shape data is complex.   To prevent data flow buffers from paging to disk and degrading performance it may be necessary to tune your Data Flow Task. Reducing the DefaultBufferMaxRows value, increasing the DefaultBufferSize value, and specifying a path to fast disk for the BufferTempStoragePath and BLOBTempStoragePath properties can all help.  For more information regarding data flow performance tuning click here.