I’m excited to kick off the 2019 Summer o’ ADF! My plan is to tag each post Summer.ADF.2019 and update this post with links to the series: Using Azure Resource Manager templates with Azure Data Factory The Recording for Using the Azure Data Factory Lookup and ForEach Activities Using the Azure Data Factory If Condition …
Continue reading Summer.ADF.2019(): Kicking off the Summer of Azure Data Factory 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. :{>
The Recording of Build and Load a Staging Database with Biml
The recording of Enterprise Data & Analytics’ free webinar titled Build and Load a Staging Database with Biml is available! Get the Code! Download the SSIS solution files here: Load AdventureWorks2017_Stage – version 0 Load AdventureWorks2017_Stage – version 1 Load WideWorldImporters Want More? Learn more from Andy Leonard and the professionals at Enterprise Data & …
Continue reading The Recording of Build and Load a Staging Database with Biml
Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities
Join me Wednesday 05 Jun 2019 for the next free webinar from Enterprise Data & Analytics titled Using the Azure Data Factory Lookup and ForEach Activities! Abstract In this demo-tastic presentation, Microsoft Data Platform MVP and author Andy Leonard walks through loading a dataset using the Lookup Activity, followed by iterating dataset values using a …
Continue reading Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities
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 in SSMS Version 18: Try SSIS in Azure Data Factory
There’s a new option when you right-click the Integration Services Catalogs node in SSMS v18: “Try SSIS in Azure Data Factory”: Clicking the “Try SSIS in Azure Data Factory” option in SSMS v18 opens the (new) Integration Runtime Creation Wizard (ISIRCreationWizard.exe, which is found in the <installation drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn directory): …
Continue reading SSIS in SSMS Version 18: Try SSIS in Azure Data Factory
SSIS in SSMS Version 18
Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features! Here’s a list of SSIS-related features: Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that …
Continue reading SSIS in SSMS Version 18
Free Webinar: Build and Load a Staging Database with Biml
The next free webinar from Enterprise Data & Analytics is titled Build and Load a Staging Database with Biml – happening 29 May 2019 at 12:00 PM EDT. Abstract Watch Andy Leonard, Microsoft Data Platform MVP and BimlHero, create a Biml solution that would build and load a staging database using Biml with minimal configuration. …
Continue reading Free Webinar: Build and Load a Staging Database with Biml
The Recording for “A Data Science Story” by Shannon Lowder is Available
Shannon Lowder (@shannonlowder | shannonlowder.com) did a fantastic job presenting the true story of a data science project. He presented the problem he was trying to solve, the places he looked for data, issues and obstacles he encountered, and solutions he developed. Enjoy! Links Storm Events files NOAA Hail Data files Microsoft Azure Machine Learning: …
Continue reading The Recording for “A Data Science Story” by Shannon Lowder is Available
Azure-SSIS Starts Faster
I had the honor to deliver “Moving Data with Azure Data Factory at SQL Saturday – Atlanta this weekend. Because Azure changes daily, I fired up an Azure-SSIS instance Integration Runtime the morning of my presentation and walked through my demo. I play a game I call, “What’s Changed in Azure!” It’s a fun game. …
Continue reading Azure-SSIS Starts Faster
SSIS Script Task Error
Has this ever happened to you? You’re tooling along building an SSIS package. You configure a Script Task, press the F5 key, and BAM! Error! DTS Script Task has encountered an exception in user code:Project name: ST_…Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) …
Continue reading SSIS Script Task Error