Groups | Blog | Home
all groups > sql server dts > february 2005 >

sql server dts : new arithabort error after some months without this error...


Jéjé
2/27/2005 3:02:00 PM
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.

dbmonitor
2/27/2005 3:27:27 PM

[quoted text, click to view]

This will sometimes occur if you create an index on a calculated
column.

Has this occured recently?

=20
[quoted text, click to view]

--
David Rowland
http://dbmonitor.tripod.com
Jéjé
2/28/2005 12:01:58 AM
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.


[quoted text, click to view]

This will sometimes occur if you create an index on a calculated
column.

Has this occured recently?


[quoted text, click to view]

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

AddThis Social Bookmark Button