Forum Discussion

sphillips-analy's avatar
sphillips-analy
Copper Contributor
Nov 08, 2024

Azure Sql Database Linked Service Lookup Activity Error

Started receiving this error when previewing results in both lookup and copy activities that are connected to an Azure SQL Database. My production pipeline (that is triggered) fails on the Azure Database lookup activity. Does anyone hav any insights on what is causing this issue? And/or how to resolve? Thanks!

  • Mks_1973's avatar
    Mks_1973
    Iron Contributor
    Nov 08, 2024

    If you're using custom code in Azure (e.g., Azure Functions), ensure that all dependencies, especially Microsoft.Extensions.Options, are updated to the required version (6.0.0.0 in this case).


    You can update the dependency in your csproj file (if applicable) by adding or updating
    <PackageReference Include="Microsoft.Extensions.Options" Version="6.0.0" />



    If you have multiple packages in your solution, there might be conflicts between different versions of dependencies. Ensure compatibility by updating all related packages to compatible versions.

    If you are using an Azure-SSIS Integration Runtime, try restarting or updating it.

    Ensure that your Azure SQL Database linked service configuration is correct, and that the connection strings and authentication methods are set up as expected.

     

Resources