Error when running a DTS Package in SQL Server 7.0

#1

Hi,

sometimes I get an error when running my DTS Package. The
error log doesn't really tell me anything useful so I
need your help.

The error message is:

.... DTSRun: Executing... DTSRun OnStart: Drop table
INVST01 Step DTSRun OnFinish: Drop
table INVST01 Step DTSRun OnStart: Create Table
INVST01 Step DTSRun OnError: Create Table
INVST01 Step, Error = -2147008507 (80074005) Error
string: Unspecified error
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.
hlp Help context: 1100 Error Detail
Records: Error: -2147008507 (80074005);
Provider Error: 0 (0) Error string: Unspecified
error Error source: Microsoft
Data Transformation Services (DTS) Package Help
file: sqldts.hlp Help context:
1100 Error: -2147467259 (80004005); Provider
Error: 0 (0) Error string:
[Microsoft][ODBC SQL Server Driver][SQL Server]
SqlDumpExceptionHandler: Process 22 generated
fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL
Server is terminating this
process. Error source: Microsoft OLE DB Provider
for ... Process Exit Code 1. The
step failed.

Any suggestions on what to do?

Greetings,
David Oxe

#2

In article <04dd01c33ed5$3329a7f0$a301280a (AT) phx (DOT) gbl>, David Oxe
<david (AT) oxe (DOT) se> writes

Quote:

Hi,

sometimes I get an error when running my DTS Package. The
error log doesn't really tell me anything useful so I
need your help.

The error message is:

snip
[Microsoft][ODBC SQL Server Driver][SQL Server]
SqlDumpExceptionHandler: Process 22 generated
fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL
Server is terminating this
process. Error source: Microsoft OLE DB Provider
for ... Process Exit Code 1. The
step failed.

This does not look like a a DTS issue, but a problem with the SQL code
in "Create Table INVST01 Step" which is causing a AV within the SQL
engine. Not nice. Isolate the code from that step and run manually in
Query Analyser. Does it work there?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

#3

In article <#sL6mKxPDHA.1624 (AT) tk2msftngp13 (DOT) phx.gbl>, David Oxe
<david (AT) oxe (DOT) se> writes

Quote:

Thanks for your quick response. When I start the script myself it
usually runs. The create table step only consists of:

select * from invst01
where invordat = '1912-08-01'

I don't know why it does this anyway. This query doesn't return any rows
since there are no invoices from that date.

Could I remove this step?

The steps are:

1) empty database invst01 (empties the database from all records from
2002-08-01 and forward)
2) create table (the select clause above)
3) data transforming step (transform the data into sql6.5 and changes
some columns so the data can be available on our intranet. also moves
the data to our inetserver)

I can't see why I would need the 2:nd step?

Greetings
David Oxe

David,
Why does you "create table" step not create a table, but run a select
instead? Maybe I misread your log file.

Ultimately you need to isolate the SQL in the step that is failing. Then
run that SQL in QA and see if you can repro the problem.

If you have steps you are sure are pointless then I would remove them,
just to try and simplify the problem.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error when running a DTS Package in SQL Server 7.0

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Error when running a DTS Package in SQL Server 7.0 - 06-30-2003 , 01:59 AM

Re: Error when running a DTS Package in SQL Server 7.0 - 06-30-2003 , 03:27 AM

Re: Error when running a DTS Package in SQL Server 7.0 - 07-01-2003 , 01:10 PM