Integration Services Extension for VS 2019 v3.8 Released

The Integration Services v3.8 extension for VS 2019 has been released! From the SQL Server Integration Services Projects page: <ShamelessPlug> Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises kickstart or complete Enterprise Data Warehouse projects – whether on-premises or in the cloud. Our experienced engineers grok enterprises of all …
Continue reading Integration Services Extension for VS 2019 v3.8 Released

Azure DevOps, Software Development, and Git Part 3 – Command-Line

I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control In this post I cover command-line …
Continue reading Azure DevOps, Software Development, and Git Part 3 – Command-Line

SSIS in Visual Studio 2019

If you’re using Visual Studio 2019 with SSIS, you may encounter an error or two when you start. One error is “incompatible” tacked onto the name of your SSIS project in parentheses: Another error you may encounter is found in the Migration Report, a local htm file that contains information about the the attenpted Visual …
Continue reading SSIS in Visual Studio 2019

SSIS Project Incompatible

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

A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion

I’m typing this at 4:30 AM IST in my hotel room in Bengaluru, India. It’s not unusual that I am awake at 4:30 AM. It is unusual that I’ve been awake since around 1:15 AM. I am attending and presenting at the Data Platform Summit 2018 and, obviously, still adjusting to the time zone. It is …
Continue reading A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion

Dude, Where’s My Controls? (Visual Studio 2017 Behavior)

I’m coding along on the next release of SSIS Catalog Compare, happy as a clam, when I realize it’s time to add a new menu item. I open the form and… nothing. To say my heart sank would be an understatement. I had questions. “Dude, where’s my controls?” “What happened?!” “Will I be able to …
Continue reading Dude, Where’s My Controls? (Visual Studio 2017 Behavior)