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
True.
~ 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
Prasad