Wendy Pastrick [Blog | @wendy_dance], (my friend) who leads the PASS Program effort on the PASS Board, recently wrote Changes to the PASS Summit 2017 Program, Pre-Conference Call for Interest, and a Community Survey. The PASS Summit 2017 Program will be somewhat different from previous years. “Different in what ways, Andy?” Excellent question, and the …
Continue reading Changes to PASS Summit Program Selection Process
Category:Uncategorized
Please Blog
My name is Andy and I’m a blogger. I encourage you to blog, too. Why? Because you know stuff. I need to learn some of the stuff you know. You’ve experienced stuff. I’d like to read your experiences – again, to learn from them. Others feel the same way. “I don’t have anything to say.” …
Continue reading Please Blog
The Recording for the SSIS Catalog Compare Version 2 Launch Event is Available
/The recording for the SSIS Catalog Compare Version 2 Launch Event is now available for viewing (registration required). Enjoy! :{> Learn More: SSIS Catalog Compare Join the DILM Suite Mailing List
Why Automate?
Because, as Jen Underwood (jenunderwood.com | LinkedIn | @idigdata) states in an upcoming podcast: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. What’s the long pole in data science? Data Integration is the Long Pole According to Lars …
Continue reading Why Automate?
Parsing SSIS Catalog Messages for Lookup Performance, v2
A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups. I’ve updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalog’s default Logging Level). Some smart data integration people recommend setting the SSIS Catalog Logging Level to Verbose and …
Continue reading Parsing SSIS Catalog Messages for Lookup Performance, v2
Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!
I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Richmond 18 Mar 2017! The Biml Express Metadata Framework is the sample code for this presentation. It’s part of the DILM Suite. I hope to see you in Richmond! :{> Learn More: SSIS Design Patterns and Biml: A Day of …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!
Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!
I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Raleigh 11 Mar 2017! You can download the sample code for this presentation at the DILM Suite website here. I hope to see you in Raleigh! :{> Learn More: SSIS Design Patterns and Biml: A Day of Intelligent Data Integration …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!
Creating SSIS Packages with the SQL Server Import and Export Wizard
This material was originally posted on the Linchpin People blog. In this post, I demonstrate how to use the SQL Server 2012 Import and Export Wizard to create a SQL Server 2012 Integration Services (SSIS 2012) package. The demo is created on a virtual machine running Windows Server 2012. You can use the SQL Server …
Continue reading Creating SSIS Packages with the SQL Server Import and Export Wizard
Long Poles and Critics
As a consultant, I get calls to complete projects started by someone else or extend projects completed by someone else. When I look at someone else’s work it’s sometimes tempting to say, "Wow – they did that wrong." But I don’t. Instead I say, "I’m not sure why they built it this way." That may …
Continue reading Long Poles and Critics
The Last SSIS Book You Read
Every now and then I get an email or meet someone at an event and they say something like, “I learned SSIS from your book!” I’m not going to lie to you, that makes me feel pretty good. Since I’ve written most of my books as part of a team, I usually reply, “It was …
Continue reading The Last SSIS Book You Read