SQL Server Integration Services(SSIS)

About this course

· SSIS makes it easy to create robust and complex solutions for extracting, Transforming and Loading the data.

· These will help you to design, create, deploy and manage packages that address everyday business requirements.

· SSIS can be used for data migration as well as data integration purpose.

· Other ETL tools are

Informatica, DataStage, abinito and data integrator.

SSIS Dev roles:

· Developing packages

· Error handling

· Debugging of packages

· Optimizing packages

· Using Scripting SSIS packages.

SSIS Administrator Roles:

· Installation

· Configuration

· Deployment

· Security

· Executing the packages

Manually

Scheduling

· Monitoring and trouble shooting in SSIS.

SSIS Architecture:

It means that four components.

1. SSIS Object model

2. SSIS Service

3. SSIS Runtime engine and

4. Dataflow engine.

1. Develop the SSIS packages by consuming the ssis object model.

2. SSIS service will manage the deployed packages.

3. SSIS runtime engine will execute the different tasks in the package.

4. Dataflow engine will executes the dataflow tasks in the package.

About the certificate

This certificate above verifies that Stefan Troehler successfully completed the course SQL Server Integration Services(SSIS) on 05/01/2023 as taught by VenkatM M on Udemy. The certificate indicates the entire course was completed as validated by the student. The course duration represents the total video hours of the course at time of most recent completion.