Re: Error: The number of failing rows exceeded the maximum specified, Help !

On Jul 25, 9:26 am, David Greenberg <davi...@xxxxxxxxxx> wrote:
Hello
I am running a DTS (Sql 2000) and transfering data from an SqlServer
database to an Ingres database.
I am transfering 153k rows.
Execution fails with the error message:
"The number of failing rows exceeded the maximum specified"

The number of rows shouldn't be a problem because in another DTS I copy
a lot more rows.
Also the width of the row shouldn't be a problem, I'm transfering only 3
int4 fields and 1 char(5) field.

Anyone have an idea what the problem could be ?

Thanks

David Greenberg

This error means that there is one or more rows (depends on [Maz erroe
count] property)which failed to transfer.
There is an option in a Transform Data Task which allow you specifiy
how many records may be dropped before entire operation is failed.
Right click on a Transform Data Task and select Properties. In
properties window select Option tab and modify Max error count in Data
movement frame, this property is set to zero by default. The most
common reason for this sort of errors to happen is the NULLs in source
rows and destination doesn't allow them.

I hope this help.

.

Relevant Pages

  • Re: Dynamically set up DTS Transformations?
    ... www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS that transform data between two databases on the same SQL ... > two data sources (I mean the mapping from the source columns to the ... > columns of destination) can be set dynamically? ...
    (microsoft.public.sqlserver.dts)
  • RE: Dynamically set up DTS Transformations?
    ... "Jamie" wrote: ... > I have a DTS that transform data between two databases on the same SQL ... > two data sources (I mean the mapping from the source columns to the columns ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Multiple Selects into One Extract
    ... into two separate sheets. ... DTS doesn't appear to be able to transform data into the same connection object because of duplicate object names. ... Create a workbook with only one worksheet. ...
    (microsoft.public.sqlserver.dts)
  • Dynamically set up DTS Transformations?
    ... I have a DTS that transform data between two databases on the same SQL ... two data sources (I mean the mapping from the source columns to the columns ... of destination) can be set dynamically? ...
    (microsoft.public.sqlserver.dts)
  • more questions about informix
    ... I need to transform data from SQLServer2000 to Informix via DTS, ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)