The Microsoft SSIS Team released an update to version 3.11 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11.1 (Current Version): Release Date: December 28th, 2020 Build Version: 15.0.2000.150 Tested against Visual Studio 2019 16.8 Bug fixes: Fixed an issue that …
Continue reading SSIS 2019 Extension v3.11.1 Now Available
Tag:SSIS
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
SSIS and the Future – December 2020 Edition
My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition
AndyTube
I’ve been live-streaming more lately. There are a number of reasons why; perhaps most trenchant is: I like to stream. On YouTube… On today’s live-stream, a viewer asked if I have a YouTube channel. I have a YouTube channel! Apparently I’ve done an awesome job publicizing that fact! Enjoy! :{>
DILM Tiers for Enterprise Data Integration
“How many Data Integration Lifecycle Management tiers (DILM tiers) do I need to manage enterprise data integration, Andy?” If I had a nickel for every time I am asked this question, I would have a lot of nickels. My answer is, “Four.” Why Four? I’m glad you asked. Before I answer, I have a question …
Continue reading DILM Tiers for Enterprise Data Integration
What’s the Best Book for Learning SSIS?
I am often asked the question, “Andy, what’s the Best Book for Learning SSIS?” There are some really good books out there that will help you learn SSIS (and I am co-author of several). The book from which I learned the most about SSIS is Extending SSIS 2005 with Script by Donald Farmer. Why do …
Continue reading What’s the Best Book for Learning SSIS?
Biml Academy – Using Biml to Build a Target Database
Using Biml to Build a Target Database is the latest unit available at Biml Academy. You can see a description of Using Biml to Build a Target Database at the link above, but I ask you to consider Basic Biml Training – which includes: Using Biml to Build a Target Database Adding Your First BimlScript Build …
Continue reading Biml Academy – Using Biml to Build a Target Database
DILM Suite + Azure Data Factory Integration Runtime
DILM Suite was designed to support enterprise data engineering / data integration with SSIS. But the solutions, utilities, and tools work well with Azure Data Factory Integration Runtime (ADF IR, or “SSIS in the cloud”). As I mentioned in my post titled The Cloud Costs Money, leaving ADF Integration Runtime running can get pricey – …
Continue reading DILM Suite + Azure Data Factory Integration Runtime
SSIS Catalog Compare vNext Preview
I am happy to announce that the next version of SSIS Catalog Compare is officially in Preview! What exactly does “Preview” mean? I’m glad you asked. It means I am sharing copies of SSIS Catalog Compare with users of the current version to get their feedback, find bugs, and help identify improvements. Here’s a screenshot: …
Continue reading SSIS Catalog Compare vNext Preview
Free Webinar – Use SSIS Catalog Compare to Lift and Shift SSIS to ADF
I’m excited to announce the next free webinar in the Summer-O’-ADF series: Use SSIS Catalog Compare to Lift and Shift SSIS to ADF! Consider… Your enterprise uses Microsoft SQL Server so the powers-that-be asked the good people at Microsoft to demonstrate the latest and greatest Azure coolness. Due to competition on cost and time to …
Continue reading Free Webinar – Use SSIS Catalog Compare to Lift and Shift SSIS to ADF