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.
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.
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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 4  Replies