FME and Microsoft SQL Server Integration Services

 

FME SSIS Extension integration

The FME SSIS Extension integrates seamlessly with the SSIS environment. You can access FME-supported formats in exactly the same way that you access any other data source connection.
FME data source

When you use the FME data source, you instantly gain access to spatial data in over 200 FME-supported formats. Here, FME is extracting source data in SDE-30 format.
Data Flow Transformation

With FME, over 200 Data Flow Transformation options become available. In this screenshot, AttributeRenamer and LengthCalculator transformations are applied to the data.
FME Destination

The FME Destination allows you to write your data to any one of over 200 formats. In this image, the data is being written to MIF.
File Destination Editor

Mapping data from source to destination schema is easy with the Flat File Destination Editor.
FME Visualization Data Flow Destination
With the FME Visualization Data Flow Destination, you can visually inspect your data to check that your data transformation is producing the results you expect.