SISS ( SQL Server Integration Services )

SSIS TRAINING : (SQL Server Integration Services) This tool is used for the integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to SQL Server etc. This tool is also used for bulk transactions in the database like inserting lac’s of records at once. We can create the integration services modules which will do the job for us.

SSIS TRAINING is the new data transformation standard for SQL Server 2005 & has replaced old SQL Server Data Transformation Services.  Integration of services has been literally re-written from the scratch, so it is nothing same as Data transformation services (DTS) for SQL Server 2000 & earlier.  Available as free 180day trail download or developer edition ($50)

SSIS Training

SSIS Training is an tool, which is used to perform the ETL operations I.e. extraction, transformation and loading of the raw data. At a very high level, SSIS provides ability to:

  • retrieve the raw data from just about any source
  • Perform various transformations on the data; example; convert from one type to another type, converting from uppercase or lowercase, perform calculations on data, etc.
  • load data into about any source
  • Then define an workflow
  • Copy the database objects
  • Perform  the FTP operations

The SSIS Training ships with an ability to connect to many data sources & destinations including :

  • OLE_ Data Base
  • ADO ,
  • ADO.Net
  • Excel and
  • Flat File

In addition to built-in connections, SSIS exposes its classes that allow developers to create an custom Connection Managers. To develop SSIS package wee need to have SQL server Business Intelligence Development Studio installed, which is available as client tool when installing SQL server management studio (SSMS).

Why to use SSIS ?

  • For rapid development (GUI means no coding required)
  • Auditable steps- easy to follow logic in schematic form.
  • Annotate notes about logic.
  • Debug.
  • Can schedule to run at set times.

SSIS TRAINING ONLINE COURSE CONTENT

SSIS USING SSMS

  • The Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS

SQL SERVER DATA TOOLS

  • Launching Data Tools
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

INTRODUCTION TO CONTROL FLOW

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task and other Control Flow Items.
  • Case Study on Usage of Control Flow items.

ADVANCED CONTROL FLOW

  • Containers – grouping and looping
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task
  • Case Study on Usage of Execute Package Tasks for Zipping and Unzipping Files.
  • The Data Mining Query Transformation
  • The Data Mining Model Training Destination
  • The Slowly Changing Dimension Transformation.
  • Demo of Adv. Dataflow Items.

EXTENDING SSIS THROUGH CUSTOM CODE

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development
  • Case Study on Creation of Master and Child Packages using Execute Package Task.

INTRODUCTION TO DATA FLOW

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations overview
  • Commonly Used Transformations.
  • Case Study for usage of Transformations and Other Dataflow components.
VARIABLES AND CONFIGURATIONS

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages.
  • Examples of usage of Variables and Usage of expressions.
  • Configuration Overview

DEBUGGING, ERROR HANDLING AND LOGGING

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The OnError event handler
  • Data Flow: Error data flow
  • Configuring Package Logging.
  • Demonstration of Logging and Configurations using a Sample Case Study.

ADVANCED DATA FLOW

  • Revisiting data sources and destinations
  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Merge and Merge Join Transformations

SSIS PACKAGE DEPLOYMENT

  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deploying and Managing SSIS Packages
  • Deployment security
  • Executing packages – DTExec and DTExecUI

SSIS PACKAGE MANAGEMENT

  • The SSIS Service and Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

APPLYING SSIS TO DATA WAREHOUSING

  • Data Warehouse Concepts
  • Populating Data Warehouse Structures using SSIS
  • SSIS General Principles

SSIS Training Course Outline:

  • Program Name: SSIS  Training
  • Course Duration:  35 Hours
  • Mode: Online virtual classes and corporate
  • Timings: According to one’s feasibility
  • System Access : will be provided
  • Batch Type: Regular , weekends and fast track
  • Trainees will get the soft copy material.
  • Sessions will be conduct through WEBEX, GOTOMEETING OR SKYPE.
  • Basic Requirements: Good Internet Speed, Headset

 Advantages upon enrolling with Tysco Online Trainings:

We are the best online training providers, we just don’t teach you the technology rather we make you understand with live examples, the sessions we conduct are interactive and informative  .If the candidates miss any of the sessions due to some unavailability, we will give assurance for back-up sessions. At the end of every week the review sessions will be taken, so that the attendees can recollect the topics. As it an Online Trainings, the timings will be according to the candidate feasibility.
As our trainers are real time experts they will help you in giving training at very high level for real time projects. At the end of the session we will discuss regarding the interview questions which will help you out in cracking the interviews. Our Consultant will help you in preparing the resume and certifications.  Also the added advantage from us is will also provide you job support if you are phasing any issue in your current job, looking at your current working technology and issue , if we think we can resolve the issue then only we give you 100% commitment to resolve it. Tysco Team will be in switch on mode for 24/7 and will solve any issues regarding the training, timings, trainer or server. We are ready to solve any issues with in no time.