All courses by Andy Leonard

  • BIML 101 for Beginners

    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
      per member
    • BIML 101: For Beginners - $259.95
      • EUR: €240.01
      • GBP: £205.70
      • NZD: $432.79
      • CAD: $352.62
      • AUD: $397.76

    Introduction to Biml An overview of Business Intelligence Markup Language (Biml). Includes demonstrations of: Building an empty SSIS package in BimlUsing BimlScript to create one empty package per tableUsing a simple metadata-driven framework built in BimlExpress to build a simple staging SSIS application. Obtain and Install BimlExpress A short course that describes acquiring the BimlExpress […]

  • SSIS for Beginners

    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
      per member
    • SSIS for Beginners - $259.95
      • EUR: €240.01
      • GBP: £205.70
      • NZD: $432.79
      • CAD: $352.62
      • AUD: $397.76

    The SSIS courses are designed “spiral-out” and “hands-on.” Spiral-out means start in the center, at the heart of the platform, and then build learning and experience around that center. Hands-on reflects the fact that we learn best by doing. Combined, spiral-out and hands-on are the best way to learn technology (or anything).

  • SSIS: The Data Flows Part 2

    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
      per member
    • SSIS: The Data Flows Part 2 - $99.00
      • EUR: €91.41
      • GBP: £78.34
      • NZD: $164.83
      • CAD: $134.29
      • AUD: $151.48

    SSIS Data Flows Part 2 builds on SSIS Data Flows Part 1 by adding a correlating Lookup and subsequent Conditional Split transformations to prevent data re-loading, or loading duplicates. This addition introduces the first order of an Incremental Load SSIS design pattern that Andy calls “Forward-Only Incremental Load.”

  • Scripting in SSIS

    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
      per member
    • Scripting in SSIS - $99.00
      • EUR: €91.41
      • GBP: £78.34
      • NZD: $164.83
      • CAD: $134.29
      • AUD: $151.48

    SSIS Scripting demonstrates the SSIS Script Task and the SSIS Data Flow Task’s Script Component, and includes .Net scripting basics in C# and Visual Basic. Andy shares templates for raising Information and Error events.

  • SSIS: The Data Flows Part 1

    • Academy Membership - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
    • Academy Membership - for Teams - From: $49.00 / month with a 2-day free trial
      • EUR: €45.24
      • GBP: £38.77
      • NZD: $81.58
      • CAD: $66.47
      • AUD: $74.98
      per member
    • SSIS: The Data Flows Part 1 - $99.00
      • EUR: €91.41
      • GBP: £78.34
      • NZD: $164.83
      • CAD: $134.29
      • AUD: $151.48

    Because Andy Leonard believes you learn best by doing, the first SSIS Data Flows course lecture demonstrates how to create an SSIS project and build your very first data flow task that includes a Flat File Source Adapter and Flat File Connection Manager to read data from a real-world source file (for http://andyweather.com) and write.