Meet & Greet at 6:30PM Presentation at 7PM
Please join and
RSVP at our
FWSSUG MEETUP page!
Abstract:
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
AutoBiography:
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).
Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors.
4055 International Plaza
Fort Worth, Texas 76109