North Texas SQL Servers Users Group

Next Meeting: Thu, Sep 21 2017



SSIS and the Cloud, Yes! They Can Get Along! 

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, SQLBitsSQL ConnectionsSQL 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.

You can visit his website and blog at or follow him on Twitter at

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

Back to Top