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.
No comments:
Post a Comment
if you have any doubt any suggestions do comment