SQL Server Integration Services is a component of the Microsoft SQL Server database software used by IT professionals to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.

See how it works: Click Here

Fast and flexible data warehousing tool used for data extraction, transformation, and loading

SQL Server Integration Services – SSIS Concepts

Connections

A connection includes information necessary to connect to a particular data source. Tasks can reference the connection by its name, allowing the details of the connection to be changed or configured at run time.

Easy to update and manipulate

Tasks

A task is an atomic work unit that performs some action. There are a couple of dozen tasks that ship in the box, ranging from the file system task to the data transformation task. The data transformation task actually copies data; it implements the ETL features of the product.

Easy to run and use

Precedent Constraints

Tasks are linked by precedence constraints. The precedence constraint preceding a particular task must be met before that task executes. The run time supports executing tasks in parallel if their precedence constraints so allow. Constraints allow different paths of execution depending on the success or failure of other tasks.

Together with the tasks, precedence constraints comprise the workflow of the package.

Event Handlers

A workflow can be designed for a number of events in the different scopes where they occur. Tasks may be executed in response to happenings within the package.

Works the way you want

Developing with SSIS

We create and maintain SSIS packages using a visual development tool based on Microsoft Visual Studio called  SQL Server Data Tools (formerly called SQL Server Business Intelligence Development Studio – BIDS). It allows us to edit SSIS packages using a drag-and-drop user interface. It has a scripting environment in which to write programming code which makes life very easy. Each package holds a variety of elements that define a workflow and upon execution the tool provides color-coded, real-time monitoring.

Users write code to define their own connection objects, log providers, transforms, and tasks

The SSIS Import/Export Wizard lets the user create packages that move data from a single data source to a destination with no transformations. The Wizard can quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.

SSIS features a programmable object model allowing developers to write their own hosts for execution. Hosts then respond to events, start and stop packages, and so on. The object model also allows us to create, store, and load packages, as well as create, destroy, and modify any of the contained objects.