
Has anyone come across this before? Any ideas on what I can do to resolve my problem? Interestingly enough, in visual studio I can parse the islolation and the select indenpendantly, just not in the same statement. This syntax will return the data correctly using a non-microsoft SQL editor, however it will will not parse corectly within visual studio. The work around syntax for the locked row on the informix DB should be: My data source SQL in the dataflow task is simple and it works great until I hit a locked record on the Informix database.

I am first creating the groundwork for the dtsx package in SQL server using the wizard, and then editing the file later in visual studio. dtsx package that imports data to SQL server 2005 from an informix 7.3 db using an ADO.net ODBC connection. dtsx Package From Informix Using ODBC Mar 9, 2006 I think my SSIS design is affected by this protocols i'm having problems with

Such as Sesoctcp and onsoctcp and the rest of the protocols Is anybody here familiar with the different informix ODBC protocol
#Informix odbc setup driver

#Informix odbc setup software
I've found two software packages (both priced in the THOUSANDS of dollars).
