Post reply

incorrect settings: ''Arithabort''

  • June 6, 2007 at 9:58 am

    #153623

    I have DTS package which was running smoothly from pst so many months and suddenly started throwing following error.

    "insert failed because the following Set options have the incorrect settings: 'Arithabort' ".

    This DTS will copy the data from a text file to staging table and then from staging table to main table. data is getting copied successfully from text file to staging table and throwing error when it copies to main table.

    Any help highly appreciated.

  • June 6, 2007 at 12:28 pm

    #711207

    One more point to be added...

    Recently i have added a column in the main table and that column was derived column and wil concatenate the two columns values to popualte. any way this new column is not part of the DTS transacation.

  • June 6, 2007 at 1:19 pm

    #711220

    I got the solution...Its started working after i altered the DB

    ALTER DATABASE Deals

    SET ARITHABORT ON

    GO

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply