Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS Import Data From Informix

Author  Topic  reenz Starting Member 29 Posts Posted - 2006-03-22 : 08:59:43 I am trying to import data from an Informix database every midnight. Each import will take in ~2million records from a table and i hae like 3 DTS package to import data from 3 different tables every night. As the Informix database server is a in-production server, I want prevent "locking" of the informix db. Is there anywhere i can set isotation to dirty read when selecting the data? Also, i would like to import data at the fastest speed possible so as to not hinder with other operations, would dts import/export wizard be good enough? As i am relatively new to ms sql, are there other ways to import data? Thirdly, i am currently using the dts wizard for import. I noticed should Informix throw any error, the dts will stop and return an informix sqlerr error and no rows will be inserted into ms sql, is there any way to implement a commit after x rows / note the errror row but skip the error row and continue / set a flag, restart e dts and continue? kindly point me in the correct direction tbanks a lot