Earlier today (26 May 2021) I took the opportunity to share another SSIS Framework Manager update. In a live stream Monday (24 May 2021), one of my Application Package Parameter scripts failed. I didn’t have time until earlier today to debug the script. What was the root cause of the failure? Bad data. Apparently, I’d …
Continue reading 26 May 2021 SSIS Framework Updates Video
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. :{>
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
T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up
This month’s T-SQL Tuesday attracted some great responses! Thank you to everyone who participated! Reitse Eskens checked in with T-SQL Tuesday #138 – Keeping up with change. For whatever reason, his pingback did not make it to my blog. I apologize for the oversight, Reitse. Thank you for reaching out so I could get this corrected. …
Continue reading T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up
How to Write a Technical Book
Open your favorite text editor. Write.
T-SQL Tuesday 138: Managing Technology Changes
I’m honored to host T-SQL Tuesday for May 2021. One point I make (repeatedly) in my latest book – titled Building Custom Tasks for SQL Server Integration Services – is “software changes.” In fact, software changed on me between the completion of editing and the release of the book! I wrote about the changes in a …
Continue reading T-SQL Tuesday 138: Managing Technology Changes
New SSIS Extension v3.13.1 for Visual Studio 2019
On 12 Apr 2021, the Microsoft SSIS Team released version 3.13.1 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. On 24 Apr 2021, the Integration Services extension was updated. The page displays this information …
Continue reading New SSIS Extension v3.13.1 for Visual Studio 2019
SSIS Framework Manager Property Overrides Video
I’m adding a GUI to DILM Suite called SSIS Framework Manager. If you read that name and guessed the GUI manages the SSIS Framework metadata, you are correct! I’ve been streaming as I’ve coded along on the project. I reached a pretty good functionality place earlier this week. Since then, I’ve been testing. I thought …
Continue reading SSIS Framework Manager Property Overrides Video
Parquet Stream
I decided to stream about Parquet files. Enjoy! :{>
One Way to Create a Parquet File from SQL Server Data
Yesterday I was coding away, deep into using C# to decompress and parse Excel XML so I could read data from a specific worksheet in a workbook on a server without Excel objects installed, when I saw the following on Twitter: For those of you who do not already know… I Don’t Switch Contexts Well I …
Continue reading One Way to Create a Parquet File from SQL Server Data
Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9
Things change. Things change in software. Things change regularly in software. If you take nothing else away from this post, please take those nuggets of wisdom. Last week, my latest book – titled Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, (Second Edition) was …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9