sql server dts: I have created a custom task in VB6 that captures error
data and calls an error logging package.

I have successfully registered the .DLL using regsvr32.

I have successfully registered the task in DTS.

The designer properties form works fine.

The task executes properly when I run the package.

I am using the Execute Package Task to run several
packages that contain this error logging task from a
parent package. If I use execute step to run the Execute
Package Task it runs the package with the error logging
custom task without problem.

When I execute the parent package, the package with the
error logging fails with a "Not Implemented" message

The Custom Task was adapted from the sample in the Wrox
book 'Professional SQL Server 2000 DTS'.

Hi Dennis,

Go to the parent package, find the execute package task that calls the
subpackage. On that Execute Package task, edit the Workflow Properties so
that it is set to "Execute on main thread". Hopefully this will resolve the
problem.

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Hi,

This is a solution to my problem, thank you for the explanations!

Geert



*** Sent via Developersdex http://www.developersdex.com ***