SQL Server Integrations Services

SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. It includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages.

Packages contains control flows with multiple control flow elements including Data Flow tasks, which in turn contains data flow elements. Other components of packages are connections, event handlers, variables, parameters, and configurations.

You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

Connectors to 3rd party databases are also available, for example:

  • Oracle DB
  • Teradata
  • MySQL

Additional information: SQL Server Integration Services Overview

%d bloggers like this: