Rick Martinez Feb 4, 2010   6:58 PM GMT

SQL SERVER INTEGRATION SERVICES. SSIS is an ETL (Extraction, Transformation, and Loading) tool tightly integrated with Visual Studio. You can select data from one or more sources and standardize, join, merge, cleanse, calculate, and perform just about any other functiion and operation for your data. One common use for SSIS is to move data from one data source to another. If you are planning a data warehouse SSIS is what you should use.

585 pointsBadges:

Colin Smith Feb 18, 2010   9:19 PM GMT

SSIS replaced the ETL tool called DTS that you may have been familiar with in SQL Server 2000.

945 pointsBadges:

edwinjhoffer Aug 24, 2015   4:56 AM GMT

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.  While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created. 

3,740 pointsBadges:

danieljones Aug 27, 2015   11:59 AM GMT

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data

2,840 pointsBadges: