On 25 Jan 2021, the Microsoft SSIS Team released version 3.12 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning that users rollback to v 3.11.1. The warning was issued 31 Jan 2021 and reads: …
Continue reading Updates to the SSIS Extension for Visual Studio 2019
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
SSIS Framework Manager Community Edition Updated
I made a few changes to SSIS Framework Manager CE (Community Edition). The most impactful change is to the SSIS Framework Application Execute functionality. In the initial (alpha!) release, framework application executions – executed from SSIS Framework Manager CE (only) – timed out at 30 seconds. This was due to the default SqlCommand timeout and …
Continue reading SSIS Framework Manager Community Edition Updated
New DataDriven Episode with Dan Burcaw
Links Sponsor: Audible.com – Get a free audio book when you sign up for a free trial! Notable Quotes BAILeY’s Introduction (00:00) “Foreshadowing” – BAILeY (00:36) Andy shares about proofing Building Custom Tasks for SQL Server Integration Services, 2nd EDition (01:30) Introducing Dan and Nami ML (05:00) Dan wrote an app – when he was …
Continue reading New DataDriven Episode with Dan Burcaw
An ADF Azure-SSIS Framework
I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework
Thoughts on an Amazon Review
In this video, I share more about a negative review on Amazon, one about which I wrote in Regarding Amazon Reviews. I’m channeling my inner Gary Vaynerchuk and addressing a critic directly. Enjoy! :{>
SQL Data Partners Episode 215: Azure Data Factory
I was honored to chat with Carlos Chacon and Eugene Meidinger of SQL Data Partners about Azure Data Factory! :{>
Announcing SSIS Framework Manager CE (Community Edition)
I’m excited to announce SSIS Framework Manager CE (Community Edition) is available for download at DILM Suite! SSIS Framework Manager CE is designed to support SSIS Framework Community Edition, providing a GUI to facilitate SSIS Framework Application creation, configuration, and management. Three views are supported in this initial edition: Catalog, Application, and Package. The Catalog …
Continue reading Announcing SSIS Framework Manager CE (Community Edition)
One Good Question
“How do I…?” I get questions that begin this way. Today, a friend reached out to ask how to search internals of SSIS packages deployed to an instance of the SSIS Catalog. My response was, “I don’t know, but this is how I would learn the answer.” I sent the following query: Select OBJECT_NAME(id) as …
Continue reading One Good Question
My Cameras Are Uncovered
The featured image for this post is a shot of my Logitech Brio webcam. It has a cover. The cover is open. Why is the camera cover open? If an individual or entity, be they public or private, accesses my webcam, I want them to catch me working or praising God. Or better yet, Catch …
Continue reading My Cameras Are Uncovered
Q & A: Learning ETL. Where Should I Focus?
A viewer on my YouTube channel asked, “Never been too deep into SSIS, but the new role I’ll be taking on involves ETL, should I be focusing on Azure Data Factory, or do you recommend I keep a foot in each of those worlds?” My response? At this time, it’s prudent to cultivate options in …
Continue reading Q & A: Learning ETL. Where Should I Focus?