Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
M.E.
Aged Yak Warrior
539 Posts |
 Posted - 2003-02-21 : 12:59:57
|
| I'm getting an error while executing a DTS package"Insert Failed because the folling set options have incorrect settings : 'ARITHABORT'"I've done some checking, Arithabort is a user setting somewhat like ansi_nulls and the sort that tells the server to abort on a divide by 0. Arithabort is currently set to 1. Why would this occour? whats going on here? any more info is helpful.-----------------------SQL isn't just a hobby, It's an addiction |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2003-02-21 : 17:09:49
|
| Ended up with a solution to this. Turned out it was because of an indexed view on the table I was trying to use DTS to insert into.I could insert into the table fine and the view would populate (through query analyzer).. everything fine and like it should be. However inserting to this table from a dts package (Exectue SQL Step) I'd have that error returned. As far as a fix... I don't really know. Since the index view had a very small use, we changed how it was made/used... Problem solved. I would like to know a better answer then just dropping the indexed view although. Kinda messed if you want my opinion.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-21 : 17:18:02
|
| Does this help (information about indexed views from BOL)?"These SET options must be set correctly for any connection that creates an index on a view or computed column. Any connection executing INSERT, UPDATE or DELETE statements that change data values stored in the indexes must have the correct settings. This includes bulk copy, Data Transformation Services (DTS), and replication operations. Microsoft® SQL Server™ 2000 generates an error and rolls back any insert, update, or delete operation attempted by a connection that does not have the proper option settings."You probably will need to do the various SET statements in your DTS package, meaning SET ANSI_NULLS ON, SET ARITHABORT ON, etc... |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2003-02-21 : 17:52:05
|
| Little more on thisAny SET options that affect the results generated by Transact-SQL statements must have the same settings for all operations referencing the index. There are seven SET options that affect the results stored in computed columns and returned by views. All connections using indexes on computed columns or indexed views must have the same settings for these seven options: These six SET options must be set to ON: ANSI_NULLSANSI_PADDINGANSI_WARNINGSARITHABORTCONCAT_NULL_YIELDS_NULLQUOTED_IDENTIFIER The NUMERIC_ROUNDABORT option must be set to OFF. Thanks TDuggan-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
|
|
|
|
|
Arithabort error?