Share via

Need help installation of OLE DB drivers to SSIS IR for DB2 connect

PHANEENDRADIVI-5643 0 Reputation points
2025-11-30T05:24:05.9466667+00:00

Hi Team,

I am trying to run an SSIS package in Azure Data Factory using an SSIS Integration Runtime. The SSIS package uses IBM DB2 as the source and SQL MI as the destination. However, the package execution is failing due to a DB2 connection issue.

According to Microsoft documentation, the OLE DB configuration for IBM DB2 should already be pre-installed in the SSIS IR, but for some reason, the connection is still failing. I also attempted to configure a custom setup, but the PowerShell installation script is not working as expected.

Could you please guide me on how to resolve this issue? I especially need help with creating a proper custom setup to install the IBM DB2 OLE DB drivers using a PowerShell script in Azure SSIS IR.

Th1000091882

ank you.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Haris Rashid 81 Reputation points
    2025-12-01T16:59:47.1033333+00:00

    You can customize your Azure-SQL Server Integration Services (SSIS) Integration Runtime (IR) in Azure Data Factory (ADF) or Synapse Pipelines via custom setups. They allow you to add your own steps during the provisioning or reconfiguration of your Azure-SSIS IR.

    The IBM iSeries Access ODBC driver is not supported on the Azure-SSIS IR. You might see installation errors during your custom setup. If you do, contact IBM support for assistance.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.