OLE DB drivers and SSIS packages

Posted in 2009

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET

Schleicher, Keith — Mon, 21 Dec 2009 14:40:35 — source: IIUG Forums & Mailing Lists

I am trying to make sure that some SSIS packages can run on a server that requires the OLE DB drivers to be installed. The servers with the SSIS packages are SQL Server machines running Windows trying to connect to a Windows 2000 machine with Informix 7.31.TD5 on it. I have run the coledbp.sql script on the Informix server. The SQL Server machines all have the Informix SDK installed so the OLE DB driver should be installed on there. What else do I need to check out to make sure that the SSIS packages can connect and that the OLE DB drivers are installed? Do I need to also get the Informix ODBC driver set up as well? Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com

↪ replying to Schleicher, Keith

Ashutosh Khunte — Mon, 21 Dec 2009 17:30:29 — source: IIUG Forums & Mailing Lists

I also setup the ODBC driver in our environment. I am using IDS V 11.x and am able to connect just fine. In addition I also ran cdotnet.sql against sysmaster database. However, keep in mind that if you are trying to use SSAS (analytics service), the OLE DB is not supported and the cube building process may crash. This is IBM OLE DB driver issue. --- On Mon, 12/21/09, Schleicher, Keith <Keith.Schleicher@searshc.com> wrote: From: Schleicher, Keith <Keith.Schleicher@searshc.com> Subject: OLE DB drivers and SSIS packages [18454] To: ids@iiug.org Date: Monday, December 21, 2009, 6:40 AM I am trying to make sure that some SSIS packages can run on a server that requires the OLE DB drivers to be installed. The servers with the SSIS packages are SQL Server machines running Windows trying to connect to a Windows 2000 machine with Informix 7.31.TD5 on it. I have run the coledbp.sql script on the Informix server. The SQL Server machines all have the Informix SDK installed so the OLE DB driver should be installed on there. What else do I need to check out to make sure that the SSIS packages can connect and that the OLE DB drivers are installed? Do I need to also get the Informix ODBC driver set up as well? Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.