I need to do a 100 GB data pull from DB2. Our db/integration server is SQL/SSIS 2014, but do not have maintenance window to install MS OLE DB2 driver soon on the db/integration server. I found though the MS OLE DB2 driver is installed on a file server in same environment. In the data flow while pulling the data, I cannot store intermediate data - due to sensitivity – it needs to be pulled directly.
I tried if there is any way to pull data directly from DB2 source to our db/integration server using the driver from this file server (while creating the data source connection manager) but could not.
Wondering if is possible and you see any solution.