I found this error confusing, too. Why? One reason was I made an assumption that the SSIS Catalog reference (a reference is an SSIS Catalog configuration setting that connects an SSIS project to an SSIS Catalog Environment) would override any values being sent from the ADF Execute SSIS Package activity to the SSIS Project / Package execution call.
Last night I presented Moving Data with Azure Data Factory to a packed house at the Richmond Azure User Group. The crowd was engaged and asked awesome questions. I had a blast! Surprise! I rehearsed many of my demos before the presentation and even updated my slides. One thing I did not do was rehearse configuring an …
Continue reading Updates to the ADF Execute SSIS Package Activity
The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity
Have you encountered this error: “Failed Get Parameter Info of parameter ____”? I ran into this error a couple times while consulting for a client to lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). The Most Likely Fix Make sure the Azure-SSIS integration runtime is running: Launch Azure Data Factory …
Continue reading Failed Get Parameter Info Error in Azure-SSIS
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 Azure-SSIS Team has done it again; they’ve added more cool SSIS execution functionality to Azure Data Factory! Execute SSIS Package Activity Update First, add an Execute SSIS Package Activity in an Azure Data Factory pipeline. On Settings, select an Azure-SSIS Integration Runtime. Set Package Location to “Embedded package”: The Execute SSIS Package activity’s properties …
Continue reading Embed an SSIS Package in an Azure Data Factory Pipeline
If you browse to an instance of an Azure Data Factory SSIS Integration Runtime – aka Azure-SSIS IR – you may notice an icon / button that appears as shown above. There are two ways to reach the Execute SSIS Package functionality, via the Monitor page and via the Author page’s Connections tab. From the …
Continue reading Execute SSIS Package in Azure-SSIS
UPDATE: View the recording of the free webinar titled Execute Azure-SSIS from Azure Files. Enjoy! :{> Join me Tuesday, 2 Jul 2019 at 12:00 PM EDT for a free webinar titled Execute Azure-SSIS Packages from Azure Files! An Updated Azure-SSIS Integration Runtime I confess: I have been waiting for this feature since I first learned …
Continue reading How To: Execute Azure-SSIS Packages From Azure Files
Last August, I had a blast at the Data Platform Summit 2018 in Bengaluru, India. One highlight of the trip was meeting and conversing with the Azure Data Factory SSIS Integration Runtime Product/Program Manager, Sandy Winarko. Sandy and I swapped coder stories and talked about data integration design patterns and I learned a few new …
Continue reading Start Azure-SSIS, Execute Package, Stop Azure-SSIS
The next free webinar in my Summer-O’-ADF series of free webinars is titled ADF Controller Design Pattern with the SSIS Integration Runtime. It’s scheduled for Thursday 5 Jul 2018 at noon EDT. It will be recorded in case you miss it. “Previously on the Summer-O’-ADF Series…” </DonLaFontaine> In my previous webinar, The Azure Data Factory Controller Design …
Continue reading Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime
