DTS error

I'm creating an import package to read a DBF into a sql table. It's all
pretty simple - no transformations or anything that ought to be difficult.
Yet when I run it, I get the error:
Copy Data from Results to Results Task
--
The task reported failure on execution.
INSERT failed because the following SET options have incorrect settings:
'ARITHABORT'.
OK
--
I cannot understand this error message. What does ARITHABORT have to do with
anything? There's no arithmetic being performed. In fact, there's only one
numeric column, an identity column being transferred from integer to integer
(and the option to allow identity setting is on). The other columns are
strings and dates.
When I tested the transformations individually, each worked fine. (They're
only simple copies anyway, no transformation being performed.)
I don't see any way to set arithabort in the package anyhow. And if I set it
in the Query Analyzer, it makes no difference.
What is this error message trying to tell me?
Also, after attempting this several times, I got a "stack overflow" message
and the Enterprise Manager abruptly quit.The ARITHABORT ON connection option is required in order to modify a table
with indexed views or indexes on computed columns.
You can set this as the database default with ALTER DATABASE:
ALTER DATABASE MyDatabase
SET ARITHABORT ON
Alternatively, you can specify this as the default at the server level by
using sp_configure to turn on bit 64 of the 'user options' bitmask.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:eByRp2ANFHA.244@.tk2msftngp13.phx.gbl...
> I'm creating an import package to read a DBF into a sql table. It's all
> pretty simple - no transformations or anything that ought to be difficult.
> Yet when I run it, I get the error:
> --
> Copy Data from Results to Results Task
> --
> The task reported failure on execution.
> INSERT failed because the following SET options have incorrect settings:
> 'ARITHABORT'.
>
> --
> OK
> --
>
> I cannot understand this error message. What does ARITHABORT have to do
> with anything? There's no arithmetic being performed. In fact, there's
> only one numeric column, an identity column being transferred from integer
> to integer (and the option to allow identity setting is on). The other
> columns are strings and dates.
> When I tested the transformations individually, each worked fine. (They're
> only simple copies anyway, no transformation being performed.)
> I don't see any way to set arithabort in the package anyhow. And if I set
> it in the Query Analyzer, it makes no difference.
> What is this error message trying to tell me?
>
> Also, after attempting this several times, I got a "stack overflow"
> message and the Enterprise Manager abruptly quit.
>
>|||Woo hoo, that did the trick. Thank you!
But how in the world is anyone supposed to know this stuff? I ran, or
thought I ran, a pretty exhaustive search on arithabort in BOL, and didn't
find this little factoid.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:u8b7okGNFHA.2680@.TK2MSFTNGP09.phx.gbl...
> The ARITHABORT ON connection option is required in order to modify a table
> with indexed views or indexes on computed columns.
> You can set this as the database default with ALTER DATABASE:
> ALTER DATABASE MyDatabase
> SET ARITHABORT ON
> Alternatively, you can specify this as the default at the server level by
> using sp_configure to turn on bit 64 of the 'user options' bitmask.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul Pedersen" <no-reply@.swen.com> wrote in message
> news:eByRp2ANFHA.244@.tk2msftngp13.phx.gbl...
>