/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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Intelligent Data Integration, SSIS Design Patterns, and Biml
On Friday, 04 Aug 2017, I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday Louisville. If you’re interested in learning more or attending, you can learn more here. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml
On DevOps…
DevOps is getting a lot of attention in SQL Server and Developer communities these days. Two friends have blogged about the outage and accompanying data loss experienced by GitLab: Brent Ozar (blog | @BrentO) wrote SQL Server DBA’s Guide to the Gitlab Outage Mike Walsh (blog | @mike_walsh) wrote DevOps: Don’t Forget The Ops I’m …
Continue reading On DevOps…