Microsoft SSIS

Deccansoft Institute

Course Summary

IT, Software & Hardware
Class room
Beginner/Entry level

Course Overview

Deccansoft is a professionally managed organization, providing automated solutions for your business needs in Latest Software and Internet technologies like MS.NET, Java-Java EE and Mobile technologies

We are in the business of change, managing complexity with an unparalleled insight, looking beyond the horizon of IT with resources focused on solutions.

We provide Software Engineering and IT organizations with a range of solutions and services in the areas of Application Development, Maintenance, Embedded Systems, Software Testing and Quality Assurance. Our superior methodologies, standards, processes, quality, and project management help us execute projects that often exceed client expectations.

Our company was built on great ideas and core values including discipline, quality and risk taking. We honor, value and celebrate the unique viewpoints of our employees, communities, customers, suppliers, and other partners in the global marketplace. The perspectives, abilities and experiences of our workforce are key to the success of our company and fundamental to our role as a technology leader.

Course Description

Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it's the solution for automating data movements. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way.

Though SSIS is almost infinitely customizable, Microsoft has produced a simple wizard to handle some of the most common ETL tasks: importing data to or exporting data from a SQL Server database. The Import and Export Wizard protects you from the complexity of SSIS while allowing you to move data between any of these data sources

Microsoft has come up with its own reporting service, in conjuction with SQL server database to introduce the Microsoft SQL Server Reporting services[SSRS]. It provides projects of type Business Intelligence Project thus enabling not only large companies but also medium-sized and small companies also to earn from its benefits. This aids in better business decisions too.

Topics Covered

    • To understand MSBI application development Lifecycle.
    • To understand basic Data Warehousing Concepts
    • To understand the Concept of OLTP and OLAP
    • To Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
    • To learn SSIS Architecture, Components of SSIS.
    • To gain complete understanding of different control flow tasks, containers and precedence constraints.
    • To gain complete understanding of wide variety of data flow Sources, Transformations and Destinations.
    • To learn to work with variables, data types, functions, expressions and parameters and providing Dynamism in SSIS
    • To develop packages using different tasks and different Transformations based on real time requirements.
    • To learn working with event handler, Logging, Configuration Files.
    • To learn Error Handling and Debugging in SSIS.
    • To learn package deployment and project deployment.
    • To gain understanding of Security and Package management

See other jobs

Share Course on :
VBA Programming
Excelgoodies Institute

Hibernate Training
Srihitha Technologies
15 Hrs