Has this ever happened to you? You are opening an SSIS project and… it won’t open. Instead of a Control Flow filled with awesome tasks and containers, you see a message in Solution Explorer telling you “The application is not installed.” You know this isn’t right because you built the SSIS project on this same machine …
Continue reading SSIS Project Incompatible
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. :{>
Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
I am honored to join my friends at the Triad SQL PASS BI Group in Greensboro North Carolina 30 Oct 2018, where I will present Faster SSIS! Abstract Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to …
Continue reading Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
Stairway to Biml 9 is Live!
I am pleased to share Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework is now live at SQL Server Central! Typing that, I realize I neglected to publicize the fact that two other Stairway to Biml articles were recently published at SQL Server Central: Stairway to Biml Level 7 – Populating the Database for …
Continue reading Stairway to Biml 9 is Live!
“Do I Need a Biml Framework, Andy?”
No. No, you do not need a Biml Framework. In the same way that I do not need a vehicle powered by an internal combustion engine, you do not need a Biml framework. You see, I live about 5 miles from Farmville Virginia. I could walk to town each time my family needs groceries. I could pack as many …
Continue reading “Do I Need a Biml Framework, Andy?”
T-SQL Tuesday: When Good Projects Go Bad
Thanks to Jeff Mlakar for hosting this month’s T-SQL Tuesday, a monthly collection of blog posts by data bloggers who work and live in the Microsoft SQL Server space. This month’s topic is about projects that have gone wrong. “Why Do Good Projects Go Bad, Andy?” Deltas. That’s all. Deltas. Allow me to explain. In …
Continue reading T-SQL Tuesday: When Good Projects Go Bad
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
I am honored to deliver Lift and Shift SSIS to ADF at the Azure DataFest in Reston Virginia 11 Oct 2018! Abstract Your enterprise wants to use the latest cool Azure Data Analytics tools but there’s one issue: All your data are belong to the servers on-premises. How do you get your enterprise data into …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
Leadership and Failure
How Do People Learn? There’s ample debate about whether people learn from mistakes. Don’t believe me? Search and see for yourself. There are compelling arguments for both learning from our mistakes and not learning from them. In engineering and software, I think we learn from our mistakes. I can hear you thinking, “Why do you think …
Continue reading Leadership and Failure
Bad Presentations
In just a few short weeks I am attending the PASS Summit 2018 in Seattle. Whenever I attend an event like the Summit or SQL Saturday I attempt to attend presentations of interest to me. I love learning new stuff! Good and Less-Good Most of the presentations I attend are good. Some are really good. They …
Continue reading Bad Presentations
Viewing SSIS Configurations Metadata in SSIS Catalog Browser
SSIS Catalog Browser is a pretty neat product. “How neat is it, Andy?” I’m glad you asked. It’s free. That makes it difficult to beat the cost. SSIS Catalog Browser is designed to surface all SSIS Catalog artifacts and properties in a single view. “What exactly does that mean, Andy?” You’re sharp. Let’s talk about why …
Continue reading Viewing SSIS Configurations Metadata in SSIS Catalog Browser
Viewing SSIS Configurations Metadata in SSMS
Let’s take a look at an SSIS Project in SSMS: Demo is the SSIS Catalog folder. Demo contains three SSIS projects named 0-Monolith, EmptySSISProject, and LiftAndShift. If we expand the LiftAndShift SSIS project we see it contains a single SSIS package named Load Customer.dtsx. The Demo folder contains two Catalog environments named env1 and env2. These …
Continue reading Viewing SSIS Configurations Metadata in SSMS