Post reply

SSIS failed to load due to ARITHABORT setting?

  • September 11, 2007 at 12:27 pm

    #118606

    I have a text file which I loaded with no problem to database using DTS, but when I use SSIS to load it into a SQL Server 2005 database it failed and the error is: SELECT failed because the following SET options have incorrect settings:'ARITHABORT'. What does this mean? I checked by select databasepropertyex('dbname', IsArithematicEnabled') and the value is 0. So what'st the problem? Thanks a million!

  • September 11, 2007 at 12:35 pm

    #732885

    It worked after I changed the ARITHABORT option to True.

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

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