Hi,

Today I received an "Arithabort" error in some DTS packages, but not all.
I have changed the arithabort option of my target database and all works
fine.

But I want to know what's append
Because its the first time I see this error and the DTS packages are the
sames. (my DTS packages has been created there is 6 months and works
correctly during this time)
Also the target database has not changed as well as my staging area
database.

The problem appear during the load between my staging area and the
datawarehouse database.

the same DTS packages works fine on other databases on the same server.
so why I receive this error today only and only on 1 database on my server?

Thanks for your help and guides.

Jerome.

Jéjé wrote:
This will sometimes occur if you create an index on a calculated
column.

Has this occured recently?


--
David Rowland
http://dbmonitor.tripod.com

I'll double check this
but I don't have any calculated columns in my datawarehouse, only in my
staging database.

maybe there is a schemabinded view or SP anywhere
I have to examine this in depth.


"dbmonitor" <dbmonitor_support (AT) hotmail (DOT) com> wrote


Jéjé wrote:
This will sometimes occur if you create an index on a calculated
column.

Has this occured recently?


--
David Rowland
http://dbmonitor.tripod.com