• Introduction and Welcome
Starting the basics
  • Introduction and Overview
  • Lecture 3: Overview of SQL Server Data Tools
Exploring Data flows
  • Transferring Data from Excel to SQL Server
  • Transferring Data from SQL server to Excel
Introduction to Data Scripting
  • Data Scripting
  • Package Configurations
Control Flow Tasks
  • Control Flow Tasks and Precedence constraints
  • Webservice Tasks
  • For Each Looping
  • Fuzzy Lookup Transformation
  • Checkpoints
  • Logging
  • Conclusion