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.
Download the materials from some of my recent presentations:
Introduction to the SSIS Catalog (Houston Tech Fest 2016)
Change Tracking Webinar (9/22/2015)
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