to Preethi:

It would be nice to do as you adviced. But there're some limitations:

--Batch is executed within transaction so any table changes would be rollbacked.

--The number of queries is...

Isn't impossible to discover compilation errors when dynamic queries are used ?

I can be wrong but there's no way to call Oracle procedure from MSSQL directly. Microsoft advises to use trigger mechanism instead.

Thanks to everybody who replied.

The only possible solution was to specify field separator explicitly in the schema.ini file.

Thanks, Simon!

That's a good thought to apply to registry. But we must use OPENROWSET statement rather than BULK INSERT because it places less restrictions and above all OPENROWSET reads metadata(columns...