469,957 Members | 2,724 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,957 developers. It's quick & easy.

Invoking DTS Transformation results in System.ExecutionEngineException

We are invoking a SQL DTS component (lets call it Comp1)
built by us in another component (Comp2).Comp1 was built
by creating the DTS package using the SQL DTS wizard and
then saving it as a VB .bas file - this was converted
to .NET class module. To this module we added some cutom
transformation tasks.

An additional info - we are invoking Comp1 in a loop
inside Comp2. The transformation succesfully happens for a
few files in the list but fails randomly.

Invoking this compponent results in the following errors
~ R6025 -Pure Virtual Function call errors
~ System.ExecutionEngineException
The system hangs after this error.
We tried the following steps.
~ Set the ExecuteInMainThread property of the Package to
~ Added the Event handlers for DTSPackage2 in the DTS
Components code
~ We installed SQL service pack 3 ( we are using Sql
Server 2000)

System Environment: VB.Net for the components and SQL
server 2000. We are using 1.1 version of the framework.

can someone suggest a way out.

Thanks in advance

Jul 19 '05 #1
0 1860

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.