SQL Server Integration Services

Why Trust Techopedia

What Does SQL Server Integration Services Mean?

Microsoft SQL Server Integration Services (SSIS) is a part of Microsoft’s SQL Server that intends to make data migration easier. It is designed for data integration and workflow for extract, transform and load (ETL) operations used in data warehousing. It replaces Microsoft’s earlier Data Transformation Services starting with Microsoft SQL Server 2005.

Advertisements

Techopedia Explains SQL Server Integration Services

SQL Server Integration Services is a data migration tool that comes with Microsoft SQL Server. It contains a number of tools for data migration. The tool lets developers build packages that move data from one database to the other. One major feature is a wizard for data import and export that can work with a variety of data types without transformation. This makes SSIS very useful for data warehousing. Users can write their own custom operations on data beyond the included wizards.

SSIS packages can be developed and edited in the Business Intelligence Development Studio with an interface similar to Microsoft Visual Studio.

All of these features make SSIS very useful for data warehousing and extract, transform and load operations.

Advertisements

Related Terms

Margaret Rouse
Technology expert
Margaret Rouse
Technology expert

Margaret is an award-winning writer and educator known for her ability to explain complex technical topics to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles in the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret’s idea of ​​a fun day is to help IT and business professionals to learn to speak each other’s highly specialized languages.