Posted by Traveller on 02/27/06 19:13

Hi All ,

I am hoping some can help or point me in the right direction. We have
recenlty installed SQL 2005 and are using integrated services using ole
db connections. We are connecting to an Informix database.

My questions is there a way I can pass through multiple sql statements
when I create a OLE DB source to the Informix database.
The reason I am doing this is we need to tell the Informix DB that we
want to use "set isolation dirty read" as well as use the Parallel Data
query part of informix.

Please bear with me as I am just starting to use SQL 2005. I have not
found a way to do this. Can anyone suggest something please.

If you need more Information please also let me know.

Thanks

Traveller

• Next in forum: Script SQL 2005 database to individual files?
• Prev in forum: Automating record selection parameters
• Thread view: Send 2 SQL statements using Integrated services

[Reply to this message]