ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

SQL Server Integration Services (SSIS)

Definition - What does SQL Server Integration Services (SSIS) 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.

Techopedia explains SQL Server Integration Services (SSIS)

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.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.