What is SSIS? How it is related with SQL Server? How does Error-Handling work in SSIS ?

HI Himsikha, SSIS is an acronym for Sql Server Integration Services. As the name suggests, it integrates the data of various sources. It is an ETL tool which can extract data from various sources, transforms the data and loads the data into database or flat files. You could argue that the extraction, transformation & load can be done using T-SQL itself but SSIS can extract from homogeneous or heterogeneous sources (such as relational dbs, flat files, XML, etc.). Error handling in SSIS can be done using the ways Amit suggested i.e., redirecting error rows or using event handlers. You could also commit, rollback transactions like we do in T-SQL. It might sound Greek and Latin when you hear redirecting error records and event handlers but it requires some insight into SSIS before you understand these concepts I'm afraid. Please let me know if you require any other information in this regard. Thanks, Vamsi Kapa read less

SSIS is an ETL (Extraction, Transformation, Load) tool where we get data from external sources and then transform that data based on the client requirement and finally we upload the data. ETL is also used to design RDW. It is the product of Microsoft SQL Server. You can do Error-Handling either by redirecting the error or by handling event logging. Thanks, Amit read less

SSIS is termed as (SQL Server Integration Service) developed by an Microsoft. SSIS is also called as ETL and DATAINTEGRATION Tools.Both ETL and DATAINTEGRATION has same definition,ETL is termed as EXTRACT,TRANSFORM and LOADING,It means EXTRACTING SOURCE FROM DIFFERENT SYSTEM, COMBINING AND APPLYING TRANSFORMATION TO ALL SOURCES AND LOADING INTO AN TARGET SYSTEM.Data Integration is also same as the name specifies Integration of Data(ALL SOURCES). Since it is an Product of Microsoft.For SSIS (SQL Server) will act as a DATABASE for LOADING the DATA. We can lOAD into DIFFERENT system Like ORALCE,TERADATA,SAP HANA,SAP BW,But (SQL SERVER) is an Default DATABASE. Errors can be Handled using different method like Flatfile,DATABASE,XML as per the project requirement. read less

SSIS-is a ETL(Extract raw data from different locations and clean,Transform finally load Load in to target database).If you are purchasing Sql server licence ssis is free of cost its part of MSBI.error Handling we can do in multiple ways each transformation has config error option.(ignore failure,redirect rows,fail task) read less

SSIS is an ETL Module in SQL SERVER stack which comes as a part of SQL installation. There are Various error prone places where we can apply different error handling techniques : Implement error handling: Handle errors by configuring data flow paths. Handle errors by configuring control flow paths. And also using Event Handlers read less