SSIS

SQL DESCRIPTION

  • Class is designed for information workers or power users who serve as SharePoint Site Owners or Site Collection Administrators. Students should take this course if they need to know how to manage the team collaboration, document management and social features of Microsoft SharePoint 2013. This class is an excellent prerequisite for IT Professionals who work as SharePoint Server Administrators attending 20331: Core Solutions of Microsoft SharePoint Server 2013.  This class can be delivered using Site Collections on an in-house server, virtual machines or Office 365

This course intended for

  • SharePoint Site Owners
  • SharePoint Site Collection Administrators
  • SharePoint Administrators and Developers

At Course Completion

After completing this course, students will be able to:

  • Manage Sites and Site Collections
  • Add users and groups and manage site, list, folder and item security
  • Add and configure web parts
  • Configure site options including theme, title, description and icon
  • Configure site navigation
  • View site activity reports
  • Customize lists and libraries
  • Work with Site Columns and Site Content Types
  • Configure Check out/in, Content Approval and Versioning
  • Create and modify pages and web part pages


SQL SERVER INTEGRATION SERVICES

 Introduction to Data Warehousing Concepts

  • What is SSIS?
  • Why we need to use SSIS?
  • Understanding basics of  SSIS
  • Understanding BIDS

 Introduction to Control Flow

  • Control Flow in SSIS
  • Control Flow Tasks
  • Workflow Tasks
  • Precedence Constraints
  • Data Processing Tasks
  • Other SQL Operation Tasks

       Introduction to Data Flows

  • Data Flow in SIS
  • Data Flow Pipeline
  • Data Flow Sources
  • Data Flow Destinations
  • Data Viewers
  • Data Flow Transformations

      Variables and Configurations

  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Understanding Property Expressions
  • Understanding Configurations
  • User Configurations
  • Using Variables and Configurations between Packages

      Advanced Control Flow

  • Advanced Control Flow Overview
  • Using Containers
  • Transactions Support in SSIS
  • Additional Control Flow Tasks

     Package Deployment

  • Overview of Deploying Packages
  • Deployment Challenges
  • Create a Package Deployment Utility
  • The Package Installation Wizard
  • Deploy a Package to SQL Server

Package Management

  • Managing packages with SQL Server Management Studio
  • Executing Packages
  • Scheduling packages with SQL Server Agent
  • SSIS Security

     Introduction to Scripting and Custom Components

  • Extending SSIS Capabilities Through Code
  • The SSIS scripting
  • Scripting in Control Flows
  • Scripting in Data Flows
  • Custom SSIS Components

                           Conclusion

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



For more details please contact here............
USA Contact:-+1-914-885-1413  ||  +1-949-209-8994 India Contact:-+91-40-60504560  ||  +1-914-885-1413 Email:-Info@globalitfamily.com



For more details please contact here............
USA Contact:-+1-914-885-1413  ||  +1-949-209-8994 India Contact:-+91-40-60504560  ||  +1-914-885-1413 Email:-Info@globalitfamily.com


Take a Free Demo class

Submit your enquire here

© 2013 : Global IT Family. All Rights Reserved