What Is Sql Server Integration Services (ssis)?

1.	What Is Sql Server Integration Services (ssis)?
Answer» SQL Server Integration Services (SSIS) is component of SQL Server 2005 and later versions. SSIS is an enterprise scale ETL (Extraction, Transformation and Load) tool which ALLOWS you to develop data integration and workflow SOLUTIONS. Apart from data integration, SSIS can be used to DEFINE workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases. SQL Server Integration Services (SSIS) is component of SQL Server 2005 and later versions. SSIS is an enterprise scale ETL (Extraction, Transformation and Load) tool which allows you to develop data integration and workflow solutions. Apart from data integration, SSIS can be used to define workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases.

Answer»

SQL Server Integration Services (SSIS) is component of SQL Server 2005 and later versions. SSIS is an enterprise scale ETL (Extraction, Transformation and Load) tool which ALLOWS you to develop data integration and workflow SOLUTIONS. Apart from data integration, SSIS can be used to DEFINE workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases.

SQL Server Integration Services (SSIS) is component of SQL Server 2005 and later versions. SSIS is an enterprise scale ETL (Extraction, Transformation and Load) tool which allows you to develop data integration and workflow solutions. Apart from data integration, SSIS can be used to define workflows to automate updating multi-dimensional cubes and automating maintenance tasks for SQL Server databases.

Discussion

No Comment Found

Related InterviewSolutions

How Is Ssis Runtime Engine Different From The Ssis Dataflow Pipeline Engine?
How Can You Configure Your Ssis Package To Run In 32-bit Mode On 64-bit Machine When Using Some Data Providers Which Are Not Available On The 64-bit Platform?
What Is An Ssis Proxy Account And Why Would You Create It?
What Are Variables And What Is Variable Scope?
What Is A Container And How Many Types Of Containers Are There?
What Is A Precedence Constraint And What Types Of Precedence Constraint Are There?
What Is A Transformation?
What Is The Data Flow Engine?
How Does Ssis Differ From Dts?
What Is Sql Server Integration Services (ssis)?