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 and Client Routing

Our shop executes "on the fly" DTS packages that copy (with a few
transformations, etc.) from one database to another database all on the same
server. One of the problems we have is that DTS routes the data stream
through the client which gives quite slow response time even for simple DTS
packages. Is there any way around this?
Surely, there's got to be a way to keep the data stream on the server
itself. All help is appreciated.Run the package as a job on the server. That's the simplest way to achieve
this. Also, you could terminal service onto the server and then invoke the
DTS package from the server itself, instead of running it from a client
machine.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:F98323F3-1D6A-4819-B160-376A37C024DA@.microsoft.com...
> Our shop executes "on the fly" DTS packages that copy (with a few
> transformations, etc.) from one database to another database all on the
> same
> server. One of the problems we have is that DTS routes the data stream
> through the client which gives quite slow response time even for simple
> DTS
> packages. Is there any way around this?
> Surely, there's got to be a way to keep the data stream on the server
> itself. All help is appreciated.

DTS "general error" when trying to export/transform to txt file

Hi there. I'm using the DTS Import/Export wizard to attempt to export data to a text file. I am using the visual basic transformations (or whatever they're called) to change column names at the destination, but that's about the most unusual or complex thing I am doing.

When I finish up, I try to save the export for later use, in the source server's Meta Data Services. It starts to save and then craps out with the following very useless error:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: General error -2147217355 (80041035)

Google turns up nothing on those number strings... anyone have any ideas, or failing that, a pointer to a tutorial page on how to create a data export script that includes the flexibility to change column names? Maybe I'm doing something wrong and don't realize it.www.sqldts.com is a good site to take a look. There might be something there.