Home / Course catalog / Y SSIS - Introduction (S123-clone)

Y SSIS - Introduction (S123-clone)


Description
Introduction to SQL Server Integration Services (SSIS)
Content
  • SECTION 1 - INTRODUCTION
  • Intro
  • Simple way to export and import data from SQL Server
  • Overview of projects and solutions in SSIS
  • Creating projects and solutions with SSIS
  • Create a New SSIS Package
  • INTRODUCTION - test
  • SECTION 2 - BUSINESS INTELLIGENCE DEVELOPMENT STUDIO (BIDS)
  • Executing a Package in BIDS
  • BUSINESS INTELLIGENT DEVELOPMENT STUDIO (BIDS) - test
  • SECTION 3 - BASICS
  • SQL Server Integration Services (SSIS) Connection Managers
  • SQL Server Integration Services (SSIS) Control Flow
  • SQL Server Integration Services (SSIS) Data Flow
  • SQL Server Integration Services (SSIS) Deployment Utility
  • BASICS - test
  • SECTION 4 - COMMAND LINE DEPLOYMENT TOOLS AND EXECUTION
  • Tools for SSIS Packages and to Execute SSIS Packages
  • Executing SSIS packages
  • COMMAND LINE DEPLOYMENT TOOLS AND EXECUTION - test
  • SECTION 5 - DEPLOYMENT
  • Deploying SSIS packages
  • DEPLOYMENT - test
  • SECTION 6 - TIPS
  • Download SSIS Samples
  • Scheduling SSIS packages with SQL Server Agent
  • SQL Server Integration Services Development Tips
  • TIPS - test
  • SECTION 7 - FINAL TEST
  • FINAL TEST
  • SECTION 8 - SURVEY
  • Feedback on Course
Completion rules
  • All units must be completed