Re: DTS Error EXCEPTION_ACCESS_VIOLATION

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 22:11:09 +0100

In message <4f7901c42c88$cbd45080$a401280a@phx.gbl>, Sandeep
<anonymous@discussions.microsoft.com> writes
>Anybody ?? Please help
>Thanks
>
>Sandeep
>
>>-----Original Message-----
>>We have some DTS jobs that runs every night called via a
>>batch file. But since the past few days we are getting
>the
>>following error.
>>
>>Error: -2147221499 (80040005); Provider Error: 0 (0)
>> Error string: Need to run the object to perform this
>>operation
>> Error source: Microsoft Data Transformation Services
>>(DTS) Package
>> Help file: sqldts80.hlp
>> Help context: 4700
>>Error: -2147221499 (80040005); Provider Error: 0 (0)
>> Error string: Code execution exception:
>>EXCEPTION_ACCESS_VIOLATION
>> Error source: Microsoft Data Transformation Services
>>(DTS) Data Pump
>> Help file: sqldts80.hlp
>> Help context: 0
>>
>>I googled around and found suggestive measures like (run
>>on the same thread process, and explicit naming of server
>>instead of 'local') but that does not help either.
>>
>>We are running SQL Server 2000 SP3 on a windows 2000
>>Server machine.
>>

If you want fast support then you can pay for it through PSS and such
like. Newsgroups are free, and people answer when they feel like it with
no obligation to even do so.

Depending on the execution mechanism and task then there are some bugs,
e.g. -
316331 - FIX: DTSTransferObjects with Events Generates an Error Message
and an Access Violation in Visual Basic
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;316331)

By far the most common cause is still to do with threading. So any VB
custom task, or even some ActiveX Script Tasks that use VB COM objects
need to be set to execute on main thread.

Also any tasks like ActiveX Script task or Dynamic Properties Tasks that
touch in any way a VB task need to also run on the main thread. This
also includes the Exec Pkg Task that executes a child package which
contains a VB task.

So examine the tasks you have a check all suitable candidate tasks are
set to run on the main thread.

If this is no help, then please describe how you execute the package,
and what tasks it contains. 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • Re: ETL rejects records intermittently
    ... The data source is the SQL SERVER 2005 table. ... We first dump the data from ... When I execute the SSIS package ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >execute rather than just assigning its sql statement and execute it later.I need the result in my Activex Script. ... > 'EXIT from function if there is another instance of the same package is running ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Text File Fails from Server Box
    ... If you are on WKSTN1 and you pick up a package from SVR1 and press execute, ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I should have specified in my question that in re-creating the text> connection, I did point in to a file local to the SQL Server. ... When I click on the>>> Destination tab, there is an execute button. ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)