Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
Use the SQL Server Integration Services platform to build enterprise-class data integration solutions.
Integration Services includes:
- Graphical tools and wizards for building and debugging packages.
- Tasks for performing workflow functions such as FTP operations, for executing SQL statements, or for sending e-mail messages.
- Data sources and destinations for extracting and loading data.
- Transformations for cleaning, aggregating, merging, and copying data.
- A management service for administering Integration Services.
- Application Programming Interfaces (APIs) for programming the Integration Services object model.
SQL Server Integration Services (SSIS) provides a rich set of built-in tasks, containers, transformations, and data adapters that support the development of business applications. Without writing a single line of code, you can create SSIS solutions that solve complex business problems using ETL and business intelligence, manage SQL Server databases, and copy SQL Server objects between instances of SQL Server.
The following are typical uses of SSIS packages:
- Merging Data from Heterogeneous Data Stores
- Populating Data Warehouses and Data Marts
- Cleaning and Standardizing Data
- Building Business Intelligence into a Data Transformation Process
- Automating Administrative Functions and Data Loading
For more information about SQL Integration Services, click here to visit the Microsoft site or contact us today.