am trying to import data from an Informix database every midnight. Eac
import will take in ~2million records from a table and i have like
DTS package to import data from 3 different tables every night.

As the Informix database server is a in-production server, I wan
prevent "locking" of the informix db. Is there anywhere i can se
isolation in DTS?

Also, i would like to import data at the fastest speed possible so a
to not hinder with other operations, would dts import/export wizard b
good enough? As i am relatively new to ms sql, are there other ways t
import data?

Thirdly, i am currently using the dts wizard for import. I notice
should Informix throw any error, the dts will stop and return a
informix sqlerr error and no rows will be inserted into ms sql, i
there any way to implement a commit after x rows / note the errror ro
but skip the error row and continue / set a flag, restart e dts an
continue?

kindly point me in the correct direction

tbanks a lo

--
reen