SQL server integration services(SSIS) introduction

    
         Microsoft SQL Server 2005 Integration Services (SSIS) is the tool set used to help you implement data integration process applications among your business application system’s files and databases. SSIS is much more than a simple extract, transform, and load (ETL) process

Basic Interactive Development Environment:-

ETL is stand for extract, transform and load:-

Transform Data: data are coming from various sources and we cannot assume that the data is structured in the same way across all the sources. We need to transform data in required format .SSIS provide large number transformation tools

 Load Data: Once the transformations are done and the data takes the form as per the requirement, we have to load the data to the destination systems.

 Load Data: Once the transformations are done and the data takes the form as per the requirement, we have to load the data to the destination systems.