| What is the use of Integration Services in SQL Server?
When we say about the use of Integration Services in SQL Server, Its main use of to merge data from multiple data stores and the update data to the data warehouse and the data marts. This will create the data transformation process logic and automate the data loading process. Below are the important components of using Integration services:-
(1)SSIS Designer
(2)Runtime Engine
(3)Tasks and Other executables
(4)Data Flow engine and Data Flow componenets
(5)API or Object model
(6)Integration Services Service
(7)SQL Server Import and Export Wizard
(8)Other tools, wizards and command prompt utilities. | | |