DTS from informix to MS SQL 2000
- From: reenz <reenz.25iewz@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Mar 2006 19:59:30 -0500
am trying to import data from an Informix database every midnight. Each
import will take in ~2million records from a table and i have 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
isolation in DTS?
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
--
reenz
------------------------------------------------------------------------
reenz's Profile: http://www.dbtalk.net/m90
View this thread: http://www.dbtalk.net/t296274
.
- Follow-Ups:
- Re: DTS from informix to MS SQL 2000
- From: Doug Lawry
- Re: DTS from informix to MS SQL 2000
- Prev by Date: EXTSHMADD New shared memory parameter?
- Next by Date: IDS 9.4 or IDS 10 Linux and VMware
- Previous by thread: EXTSHMADD New shared memory parameter?
- Next by thread: Re: DTS from informix to MS SQL 2000
- Index(es):
Relevant Pages
|
|
