FWSSUG - Ryan Casey: "Real World" Examples-Load Data Warehouse with SSIS

Fort Worth SQL Server Users Group
Fort Worth SQL Server Users Group
Public group

Location visible to members


Ryan Casey presents:

"Real World" Examples on How to Load Data Warehouse Structures using SSIS

In this session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.

Live Demo SSIS Framework

• Load & Error Meta Data

• Restart ability, Rollback, Reload Count

• Master Load ID, LoadID, ExecutionID (SSISDB), Refresh

• Package Sequencing and Signatures

• Connections, Expressions, Parameters, Event Handlers

• Alerting (SMTP), Error Flows (XML Destination Script)

Forward Engineering SQL Structures

• Relationships, Primary & Foreign Keys

• Data Types, Nullability, Indexes

Demos for Multiple Design Patterns

• Dimensions (Slowly Changing)

• Facts (Inserts, Updates, Deletes)

• Bridges / Snowflakes



Ryan Casey, MBA, LLC
@AimYourData on Twitter

BI Architect, AIM Business Driven Data Solutions

Website: http://www.aimyourdata.com/

LinkedIn: https://www.linkedin.com/in/ryancaseymba/

Facebook: https://www.facebook.com/aim.yourdata.9

Blog: http://www.rhynodata.com/

You Tube Channel: https://www.youtube.com/channel/UCd4RTLBn8sjVR5D3gfJhq9Q

Microsoft Data Platform MVP, Public Speaker, and Group Moderator

SQL Saturday Speaker @
• Dallas, TX 2018, 2017 (BI), 2016, 2015
• Phoenix, AZ 2018, 2017 (BI)
• Kansas City, MO 2017
• Baton Rouge, LA 2017
• Oklahoma City, OK 2016
• San Antonio, TX 2016

SQL User Group Speaker @
• NTSSUG, Dallas, TX
• CACTUSS, Austin, TX
• OKCSQL, Oklahoma City, OK
• MSBIC, Dallas, TX
• SALSSA, San Antonio, TX
• FWSSUG, Fort Worth, TX

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).