Summary: SQL Server Integration Services (SSIS) has been around since the cloud was just a term to describe the weather. SSIS is great at handling most any on-premises data load need, but that doesn’t mean that it can’t be used for cloud or on-prem/cloud hybrid architectures. With the flexibility in its legacy behaviors and the new cloud-specific tasks and components, Integration Services is versatile enough to wrangle both traditional on-prem and cloud-based ETL needs.In this session, we will cover how SQL Server Integration Services can play well with the cloud. We’ll review and demonstrate how existing SSIS tasks and components can be used for cloud or hybrid load scenarios, and will walk through some of the newest tools built specifically for cloud endpoints. We will also discuss the role SSIS plays in the enterprise alongside other cloud data integration tools, including Azure Data Factory (ADF).
Presenter: Tim Mitchell
Tim Mitchell is a business intelligence consultant, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is the founder and principal data architect at Tyleris Data Solutions.
As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.
Date: Thursday, September 21st, 2017
Meeting starts: 6:00 pm with food and a QA session
Presentation: 6:30 pm to 7:30 pm
Microsoft Las Colinas Offices
7000 North Highway 161 , Building LC-1
Irving Texas 75039
Afterward socializing: If there is interest, we will gather at NYLO (1001 W Royal Ln, Irving, TX 75039) to casually socialize