Gehan,

  On the 'Transform Data Task' in question (ie the DataPump),
you have the ability under the 'Options' tab (right click
on the task and select properties, then click on the
Options tab) to select several settings which can help
you debug the problem.
.  Exception file name: The name of a file that will be
   written showing any rows that fail.  This way you can
   go back and see what was causing you grief.
.  Max Error Count: By default this is zero so it will
   stop when it encounters the first error.  Set it higher
   so you can get the good data imported.
.  First Row/Last Row:  If you know you have a particular
   row (or sequential rows) that have invalid data, you
   can start and stop the task so that it picks up only
   what you want.  Generally when the task stops, it will
   tell you what row it was processing.
.  Insert Batch Size:  You can process the input side in
   chunks which may or may not be appropriate in your case.
   If you do, the max error count above refers to how many
   of these batchs must have errors, not how many errors
   there are within a particular batch.

  DTS is VERY powerful and we've used it for several
different customers including importing HP3000 data.

Regards,
Michael L Gueterman
Easy Does It Technologies
http://www.editcorp.com
voice: 888.858.EDIT or 573.368.5478
fax:   573.368.5479
--


-----Original Message-----
From: "Gehan G." <[log in to unmask]>
To: [log in to unmask]
Date: Fri, 20 Feb 2004 10:11:11 -0800
Subject: [HP3000-L] Transfering databse table from HP to MS-SQL (mostly
OT)

>  This is more of a sql question then an HP one but I was
> hopeing someone could help me out...
>
>  I'm using an SQL DTS to transfer some database tables to an
> SQL server. I've transfered most of them but a few of them
> are getting errors. This is an example of a typical error:
> ________________________________________________________
<snip>

> Does anyone have any way I can get these tables to transfer,
> is there a "drop record on error and continue option" that
> I'm missing?

<snip>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *