<div>
SET ARITHABORT OFF<br />
<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_5tys.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_5tys.asp</a><br />
<br />

</div>


SET ARITHABORT OFF

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_5tys.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_5tys.asp]



<div>
I tried that- i still get the same thing
</div>


<div>
I think the problem is that i created an indexed view with a table, then truncated the table and I am now again trying to load the table with new data.<br />
I tried SET ARITHABORT OFF from query analyzer- and then tried running the package but i still get the same error
</div>


I think the problem is that i created an indexed view with a table, then truncated the table and I am now again trying to load the table with new data.
I tried SET ARITHABORT OFF from query analyzer- and then tried running the package but i still get the same error

<div>
would like to delete the question - as i solved it by removing the indexes on the view<br />
thanks
</div>


would like to delete the question - as i solved it by removing the indexes on the view
thanks

<div>
thanks for the useful links
</div>


<div>
<div class="content wysiwyg-content">
When i run a DTS package- which was correctly working earlier, I get the following error.<br />
INSERT failed because the following SET options have incorrect settings:'ARITHABORT'<br />
All that this package is doing is loading a flat file to a table.<br />
<br />
I had created an indexed view based on the table. After which i truncated the table.<br />
<br />
Since I was getting this error, I deleted the indexed view.<br />
<br />
However, the error still persists- what should I do to fix it?
</div>
</div>


When i run a DTS package- which was correctly working earlier, I get the following error.
INSERT failed because the following SET options have incorrect settings:'ARITHABORT'
All that this package is doing is loading a flat file to a table.

I had created an indexed view based on the table. After which i truncated the table.

Since I was getting this error, I deleted the indexed view.

However, the error still persists- what should I do to fix it?

ARITHABORT Error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.