The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity
Category:Data Engineering
How I Build an SSIS Test Virtual Machine
I use VirtualBox for my hypervisor engine. I started using it years ago when it was the first free hypervisor I found that supported 64-bit guests. In this post I share some thoughts about testing SSIS using a test virtual machine (VM). There are other awesome hypervisor platforms out there. In setting up a virtual …
Continue reading How I Build an SSIS Test Virtual Machine
SSIS Design Pattern: Controller Pattern
The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).
Two Recordings Available: SSIS Catalog and SSIS Lifecycle
Andy Leonard shares two recordings about using the SSIS Catalog to manage enterprise data engineering.
You Might Need an SSIS Framework
You might need an SSIS framework. “How can I tell if I need an SSIS framework, Andy?” I’m glad you asked. Does your enterprise: Practice DevOps? Execute lots of SQL Server Integration Services (SSIS) packages? Execute SSIS packages several times per day? Execute “SSIS in the Cloud” using the Azure Data Factory version 2 Integration …
Continue reading You Might Need an SSIS Framework
Deploying to the SSIS Catalog Changes the Protection Level
I recently answered a question on the SQL Community Slack #ssis channel about SSIS and security. Let me begin by stating that SSIS security is complex, made up of many moving parts, and not trivial. If you struggle with SSIS security configuration, you are struggling with one of the harder parts of SSIS. Protection Level …
Continue reading Deploying to the SSIS Catalog Changes the Protection Level
Honored to be a Certified Microsoft Big Data Professional
I’m so excited and honored to be a Microsoft Certified Big Data Professional! I enjoyed the courses and learned a lot the past seven months. It was super cool to work with Frank La Vigne – co-host of the Data Driven podcast – on the capstone project. (Any time I get to work with Frank, it’s …
Continue reading Honored to be a Certified Microsoft Big Data Professional
An Abbreviated History of Andy, Part 1
Introduction After Paul Randal (Blog – @PaulRandal) tagged him in a post about the three events that brought him here, Brent Ozar (Blog – @BrentO) tagged me in his cleverly titled You may ask yourself, How did I get here? So. How did I get here? 1. Christy I recently read an article about how some …
Continue reading An Abbreviated History of Andy, Part 1