'Creating Multiple Informix Servers in Setnet32

New to SSIS. Database info:

  • Source DB: Multiple Informix servers that run the same application hence the same Informix database name across all these servers.
  • Destination DB: Single SQL
  • Requirement: Extract data from all source Informix servers and import to SQL
  • Challenge: Installed Informix SDK on SQL and running Setnet32 to setup IBM Informix Server. Setnet32 defines server entry by Informix Server "instance name". This creates a problem because all of my source databases are using the same "instance name" and cannot be changed, and therefore there is ONLY one Server entry in Setnet32. Subsequently, only a single ODBC can be created for the specific Informix server.

Question:

  • Since I am new to SSIS, I feel I did something fundamentally wrong. What is the correct solution here?
sql-serverssisodbcinformix


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions