I am in the midst of incrementally publishing a guide to ETL best practices. This guide is platform-agnostic, intended to highlight recommended methodologies for ETL architectures on any platform.
I am also writing a series of posts on using SSIS in the cloud.
Download the materials from some of my recent presentations:
Are There Time Bombs in Your SSIS Packages? (SQL Saturday Dallas, May 2018)
Intro to Biml (SQL Saturday Dallas, May 2018)
Introduction to Azure Data Factory (Live360, November 2017)
Loading a Data Warehouse with SSIS (Live360, November 2017)
Introduction to Azure SQL DB (Live360, November 2017)
Advanced SSIS Package Authoring with Biml (Live360, November 2017)
SSIS and the Cloud: Yes, They Can Get Along (PASS Summit, October 2017)
Testing SSIS Packages (PASS BI Virtual Chapter, April 2017)
SQL Server Live (Orlando, Florida 2016)
Please note that all code is provided as-is with no expressed or implied warranty. Use at your own risk.
Stuff I read
Data Loading Performance Guide – Loading lots of data into SQL Server? You need to read this.
BimlScript.com is a great resource for learning and using Biml. Code snippets, videos, and how-to guides will help you get started, and are great resources to use for reference when building Biml and BimlScript solutions.
BIDS Helper is a Visual Studio add-in with some nice features for SSIS. All the cool kids are using BIDS Helper.
Notepad++ is Windows Notepad on steriods. ‘Nuff said.
Konesans.com produces a great Trash Destination and Data Generator for SSIS, among other tools.
Here’s a listing of a ton of free SQL Server utilities. Enjoy!
ConnectionStrings.com – The place to find any connection string you will ever need.
SSIS to SQL Server data type translation
SQL Server, SSIS, and Biml Data Type Reference