.dtsx Package From Informix Using ODBC

Help!

I'm trying to create a simple .dtsx package that imports data to SQL server 2005 from an informix 7.3 db using an ADO.net ODBC connection. 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.

My data source SQL in the dataflow task is simple and it works great until I hit a locked record on the Informix database.

select <coulmns>

from <table>

Where <condition>



The work around syntax for the locked row on the informix DB should be:

set isolation to dirty read

go

select <coulmns>

from <table>

where <condition>

This syntax will return the data correctly using a non-microsoft SQL editor, however it will will not parse corectly within visual studio. Interestingly enough, in visual studio I can parse the islolation and the select indenpendantly, just not in the same statement.

Has anyone come across this before? Any ideas on what I can do to resolve my problem?

Thanks in advance!