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

2 answers

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
  2. VRISHABHANATH PATIL 1,820 Reputation points Microsoft External Staff Moderator
    2025-12-05T05:55:26.2133333+00:00

    Hi @PHANEENDRADIVI-5643

    Thank you for reaching out to Microsoft QA. Below are some mitigation steps that may help resolve your reported issue -

    Restore Admin Access

    Reset SQL Server admin password or assign Azure AD admin via Azure Portal. Use admin account to create or map users and grant roles (db_datareader, db_datawriter, db_owner). KB References: KB articles, KB articles. Fix OLE DB Provider Error

    Install IBM DB2 OLE DB provider matching runtime bitness (32-bit or 64-bit). If only 32-bit provider exists, run SSIS in 32-bit mode. References –

    Customize setup for the Azure-SSIS integration runtime

    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.