Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem using WithEvents and DTS.Package
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Problem using WithEvents and DTS.Package
Miscellaneous
Thread ID:
00510277
Message ID:
00510277
Views:
43
While running a VB program that is using the DTS.Package object, I receive the error "Error Message: "Exception Access Violation 2147221499.Need to run the object to perform this operation" Occurs When You Run a DTS Package in Microsoft Visual Basic Code" exactly as described in articles :
http://support.microsoft.com/support/kb/articles/Q221/1/93.ASP
http://support.microsoft.com/support/kb/articles/Q271/8/89.ASP

I have added dummy code (add trace to a text box) as described in these articles but I still have the problem.


In the event viewer, I have this error message:

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Need to run the object to perform this operation

Error code: 80040005
\Error Help File:sqldts80.hlp
Error Help Context ID:700


Package Name: Package20010420
Package Description: DTS package description
Package ID: {34FABB22-4EB7-11D5-8DD0-0004AC6E905B}
Package Version: {34FABB22-4EB7-11D5-8DD0-0004AC6E905B}
Package Execution Lineage: {34FABB23-4EB7-11D5-8DD0-0004AC6E905B}
Executed On: MTL6064
Executed By: MorE999
Execution Started: 5/22/01 9:34:49 AM
Execution Completed: 5/22/01 9:34:51 AM
Total Execution Time: 1.973 seconds

Package Steps execution information:


Step 'Copy SQL Server Objects' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Need to run the object to perform this operation
(Microsoft SQL-DMO (80004005): [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION)
Step Error code: 80040005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700

Step Execution Started: 5/22/01 9:34:49 AM
Step Execution Completed: 5/22/01 9:34:51 AM
Total Step Execution Time: 1.963 seconds
Progress count in Step: 0
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Reply
Map
View

Click here to load this message in the networking platform