Download the materials from some of my recent presentations:
Next Level SSIS series – North Texas SQL Server User Group (June-Aug 2014)
SSIS Scripting – SQL Saturday #271 Albuquerque (01/25/2014)
Data Cleansing in SSIS – SQL PASS Summit 2013 (10/16/2013)
Maximizing SSIS Package Performance – SQL Saturday #232 Orlando (9/14/2013)
Handling Errors and Anomalies in SSIS – SQL Saturday #223 OKC (8/24/2013)
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