Failed Get Parameter Info Error in Azure-SSIS

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

How to Get ADF to List Available Properties

Did you know Azure Data Factory (ADF) will actually list available properties? It will. One of the things I cover in my ADF training titled Master the Fundamentals of Azure Data Factory is this handy troubleshooting tip. An Error I am attempting to read the status of a pipeline execution using a call to the ADF …
Continue reading How to Get ADF to List Available Properties

ADF Activity State Property Disables Pipeline Activities

Update: Chenye Charlie Zhu has posted an excellent article about this new functionality over at the Microsoft ADF blog! It’s titled Comment Out Part of Pipeline. Part of one of my consulting gigs is helping a client lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). While developing some test pipelines …
Continue reading ADF Activity State Property Disables Pipeline Activities