SQL Server Integration Services

SQL Server Integration Services (SSIS) allows you to:

  • Pull data from a data source

  • Apply transformations, written in VB, to the data

  • Push the transformed data to another data source

The earlier version of SQL Server Integration Services is Data Transformation Services (DTS). If you used DTS in the past with older versions of Microsoft SQL Server, be aware that DTS is a 32-bit application. If you now have newer versions of Microsoft SQL Server and if you are now running on a 64-bit system, see the Microsoft support site for instructions on how to run DTS packages in 32-bit mode and how to migrate DTS packages to SSIS.

Also, OLE DB Object Services is a 32-bit provider. See the Microsoft support site for instructions on how to use SSIS with 32-bit providers.

At this time, the connector supports only full database query file extractions with SSIS. If you want to have better control over the data extracted from the database or to extract Form information, you must use Microsoft SQL Server (MSS) as the data source and create a heterogeneous query with MSS.