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...
>

DTS Error

Hi,
Can any body help me to sort out this problem

I am running a DTS package source as dbf file and destination as sqlserver database the following error occurs

for row number 2035 errors encountered so far on this
task 1. insert error, column 3 ('arch_dt', DB_TYPE DBTIMESTAMP)

when i was opening dbf file in foxbase its showing (arch_dt field) date as datatype the same when i was importing to access the datatype is changing to text type.

so daily manually i am opening in excel file and delete the records where the line error occurs.

in excel file that particular row will have some text format instead of dateformat.

how can i solve this error without manual interaction..

with regards
rajkumarIf you insert it as a chracter datatype then you can check the value and correct it.
You could also probably use an activex script on it but that would be slow.

Dts

Hi,
I have a dts package that I created which uses an odbc connection to go and
copy a dbf file using visual fox pro drivers to a sql server database. The p
ackage runs fine when I execute it manually. But whenever I try to use the s
ql server agent(schedule) to run it as a job, it doesn't work. I realy dont
know what to do...
Thanks for the helpCan anyone help me ?