Overview of SQL Server Integration Services (SSIS)SSIS is an integration layer API built over SQL Server. It’s used for building data integration, workflow, and ETL operations based solutions with high performance. It is a GUI based platform including wizards for building and maintaining packages, workflow tasks, SQL statements execution, e-mail messaging, data sources and destination for extracting transforming and loading data (ETL), and management services for administering Integration services.
SSIS consists of the following tools/concepts:
- Control flow
- Data flow
- Connection managers
- Package configurations
- Property expressions
- Data sources and data source views
Overview of SQL Server Integration Services (SSIS) SQL Server Integration Services is used for building applications with data integration and workflow. SSIS is most commonly used in ETL jobs of data warehousing. It can be used for automation of SQL server’s database maintenance. SSIS has a unique feature to move data from a single data source to a destination with no transformations.