SSIS Framework Manager Updated

I am so excited to announce scripting in SSIS Framework Manager – a new component of the Data Integration Lifecycle Management Suite – is code complete! My first-pass testing worked really well, so I decided to go live on LinkedIn Live and demonstrate it. I practiced a few test-walk-throughs and it all worked. As is …
Continue reading SSIS Framework Manager Updated

Azure DevOps, Git, and SSIS

After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS

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

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

On Output…

I’m going to be a little bold in this post and suggest if you are developing for SQL Server, the screenshot to the left and above shows something that is, well, wrong. I can hear you thinking, “What’s Wrong With That Output, Andy?” I’m glad you asked. I will answer with a question: What just …
Continue reading On Output…

Coming Soon: SSIS Catalog Compare Updates

I spent a lot of time this year writing and managing a book project. I will blog about that later, I promise. While I enjoy writing it really cuts into my play time. What do I do when I play? I write software. This weekend I cracked open the code for SSIS Catalog Compare and …
Continue reading Coming Soon: SSIS Catalog Compare Updates