Post reply

SSIS INFORMIX Connectivity

  • October 21, 2008 at 1:20 pm

    #194785

    Hi,

    I am novice to SSIS and in process of ETL tool selection.

    I am trying to connect to a Informix database.

    I am able to create a ODBC connection to that Informix database and test it successfuly.

    I added One Informix database as data Source in SSIS.

    When I tried to create a DataSource View on one table I got below error.

    ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. (iclit09b.dll)

    Tried to google ..without much help.

    Also suppose i am able to connect to Informix ..I will have to use Data Reader Source Object to connect to it (as i need to use ODBC connection for IBM Informix).Is this a correct statement ?or I have to use OLEDB data source ?

    When I a look into Data Reader Source task I see this error (i can not modify its content)

    Error at DataFlow task Datareader Source (95)Runtime connection manager with ID can not be found verify that connection manager collection has a connection manager with that ID

    Thanks and Regards!

    Abhishek

  • November 7, 2009 at 7:24 am

    #1076330

    I am receiving the same error as well....any help?

  • November 7, 2009 at 8:56 am

    #1076352

    Hi

    I have no clue about SSIS and Informix, but SSIS is a .NET application. Probably it helps to install the Informix .NET provider:

    http://uda.openlinksw.com/dotnet/mt/dotnet-informix-mt/

    Hope this helps!

    Flo

  • February 14, 2012 at 6:19 am

    #1446805

    I got the same error. I used SQL Command from the dropdown in SSIS instead of Table or Views and then used Select * from Table_XX (or with where clause).

    It works.

    Try it out.

  • February 14, 2012 at 6:22 am

    #1446806

    I used ODBC as OLEDB providers still have some issues.

  • February 15, 2012 at 4:08 pm

    #1447607

    We are in the process of migrating from a SQL2005 data warehouse solution to a SQL2008. We have used an ODBC connection to our informix patient management system for a long time without any problem.

    However moving to SQL2008 has proved to be tricky.

    1. ODBC Informix connection creates empty rows if Service Pack 1 is loaded onto the Server.

    2. OLEDB Informix , datareader sources fail if free text fields contain control characters.

    3. Informix Dot NET Provider + ADO.NET (Version 3.5 client-sdk) works the best so far. Only limitation so far is that any derived column will fail if error handling is set to FAIL and it tries to convert control chracters. Set error handling to ignore, allows text through.

    We are presently carrying extensive out tests to confirm reliability.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply