The SQL Server Integration Services Projects extension for Visual Studio 2019 was updated 20 Apr 2020. There are also recent updates to Microsoft® OLE DB Driver 18 for SQL Server® and the GitHub Extension for Visual Studio. Happy coding! :{>
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. :{>
The Summer o’ ADF, v2020
I am pleased to announce the Summer o’ ADF, v2020, is on! Webinars: [Recording] Updates to the SSIS Framework Posts: [Recoding] Building an SSIS Framework in Azure Data Factory One Way to Incrementally Develop ADF Pipelines Nesting ForEach Activities in Azure Data Factory [Recording] Using the Azure Data Factory ForEach Activity [Recording] Configuring and Managing ADF …
Continue reading The Summer o’ ADF, v2020
One Way to Create Login Credentials
In the age of password managers, like LastPass, I no longer remember passwords. Instead, my password manager remembers them for me. I’ve found another use for password managers: generating the username portion of a username-password login. When it’s time to create the credential, I use the LastPass plugin’s “Generate Secure Password” function: I copy the password …
Continue reading One Way to Create Login Credentials
Azure Data Factory Supports Excel Files
Excel format in Azure Data Factory. A welcome addition to ADF! When adding an ADF DataSet: I am convinced they got tired of me saying, “Well, you’ll need SSIS if you want to read Excel…” Probably not, though. Either way… score! :{> Need Help Migrating to Azure? Enterprise Data & Analytics specializes in helping enterprises modernize their data …
Continue reading Azure Data Factory Supports Excel Files
An Introduction to Azure Data Factory REST API
TL;DR: To read the value portion of a key-value pair stored in JSON in an ADF pipeline, interrogate properties.<key>, where key is the key-part of the key-value JSON pair. Introduction Last month I wrote a post titled Stop an Azure-SSIS Files Integration Runtime (Safely). The post generated a bunch of hits, which is awesome. The …
Continue reading An Introduction to Azure Data Factory REST API
Announcing Summer 2020 ADF and SSIS Courses!
Due to popular demand, Enterprise Data & Analytics announces additional Azure Data Factory and SSIS training this summer! 06-07 Jul 2020: Expert SSIS 08 Jul 2020: Master the Fundamentals of Azure Data Factory For a limited time, all Enterprise Data & Analytics training is 50% off, including our popular ADF and SSIS Season Pass! Expert SSIS Do …
Continue reading Announcing Summer 2020 ADF and SSIS Courses!
Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes
Join me 22 Jun 2020 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar – Configuring and Managing ADF Azure-SSIS Integration Runtimes! Abstract Azure Data Factory (ADF) includes Azure-SSIS Integration Runtimes, a mechanism by which SSIS packages are executed in Azure! Join Data Platform MVP Andy Leonard as he discusses and demonstrates …
Continue reading Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes
Enterprise Data & Analytics is a SentryOne Partner
Did you know Enterprise Data & Analytics is a SentryOne Partner? We are! And we are honored to partner with SentryOne. We may have been the first partner to sign up in support of Task Factory – SentryOne’s suite of SSIS components and tasks – and SentryOne Test – which supports BI Testing. The Data …
Continue reading Enterprise Data & Analytics is a SentryOne Partner
Stop an Azure-SSIS Files Integration Runtime (Safely)
Recently, it happened to me. Again. I delivered another round of SSIS and ADF training, and I forgot to stop an Azure-SSIS integration runtime. I left it running for a few days and it cost me, well… more money than it would have cost me if I had remembered to stop it! Regarding the “Stop …
Continue reading Stop an Azure-SSIS Files Integration Runtime (Safely)
The SSIS Catalog and SCCPAC Files
The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files