SQL SERVER INTEGRATION SERVICES (SSIS)

purpose of ssis

• It's ETL tool (Extract, Transform, Load)
• Used mostly in Data warehousing projects
• Used for Data Migration projects
• Used for Data Migration projects

• data preparation layer is also called as data warehouse layer
• ssis is used in data preapration layer

• ssis is used for data injection from source to data warehouse layer
• ssis is used for movement of data from source to stagging layer then to data warehouse layer
• when ever data movement is needed then we use ssis

Components of SSIS

• on this tool we perform ETL Operation or automation process
• the ETL Process can be done through Data Flow Task

control Flow

• control flow controls the flow of execution