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?