topic Self Hosted Integration Runtime in Dataflow

Self Hosted Integration Runtime

halll_sc — Thu, 16 Jan 2025 15:35:52 GMT

Have a flow that has been copying data from Redshift to an Azure SQL database for some time now. This flow has been working since its inception but today it started to fail and in looking at the reason the copy activity linked service to Redshift is failing with the following error.

ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Amazon Redshift ODBC Driver_1.5.14.1017, C:\Program Files\Microsoft Integration Runtime\5.0\Shared\ODBC Drivers\Microsoft Amazon Redshift ODBC Driver_1.5.14.1017\lib\AmazonRedshiftODBC_sb64.dll).

I logged into the remote VM running the agent and from what I can tell the agent is running as expected and the above mentioned file is in the directory specified in the error.

Just wanted to see if anyone has dealt with a similar issue.

Re: Self Hosted Integration Runtime

halll_sc — Thu, 16 Jan 2025 16:17:43 GMT

Update: I went as far as uninstalling and reinstalling the integration runtime agent on the VM and still getting the same error regarding not being able to locate the ODBC driver.

Re: Self Hosted Integration Runtime

Anonymous — Fri, 17 Jan 2025 06:15:24 GMT

Hi halll_sc ,

Based on the error message, the problem may be related to a gateway upgrade. It may be worth checking if any recent updates or changes have triggered the issue.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.