What is SSIS (SQL Server Integration Servers)

 Microsoft SSIS or Microsoft SSIS or SQL Server Integration Services is a data migration and integration tool that comes with the Microsoft SQL Server database that can be used to extract, integrate, and transform data. SSIS is an Extract, Transform and Load (ETL) solution.

SSIS is an upgrade of Data Transformation Services (DTS), which was an old data transformation solution included with SQL Server. The tool comes with the Microsoft SQL Server database and is used to extract data from relational databases and files so that it can be transformed.

File types supported by SSIS include XML, flat files, and Microsoft Excel. Many enterprises use the software as a data warehousing solution. Some of the tasks you can do with SSIS include:

·       Analysing

·       Cleansing

·       Loading

·       Transformation

·       Aggregation

·       Merging

Extraction is a data migration and integration tool that comes with the Microsoft SQL Server database that can be used to extract, integrate, and transform data. SSIS is an Extract, Transform and Load (ETL) solution.

SSIS is an upgrade of Data Transformation Services (DTS), which was an old data transformation solution included with SQL Server. The tool comes with the Microsoft SQL Server database and is used to extract data from relational databases and files so that it can be transformed.

File types supported by SSIS include XML, flat files, and Microsoft Excel. Many enterprises use the software as a data warehousing solution. Some of the tasks you can do with SSIS include:

• Analysing
• Cleansing
• Loading
• Transformation
• Aggregation
• Merging

Extraction