May 8, 2002 at 11:44 pm
DTS objects loaded:
DTS.Package
DTS.Connection
DTS.Step
DTS.Task
DTS.DataPumpTask
DTS.Transformation
DTS.Lookup
DTSPump.DTSTransformScriptProperties
I built a DTS Custom Task using VB ActiveX Scripting utilising the above DTS objects in VB6.
The custom task is added to the DataPumpTask to a monitor (a DLL that implements the Custom Task interface) that monitors progress/transforms and reports errors via GlobalVariables etc.
Development was on SQL Server 7.0
When it came to implementing the app on machines with MSDE, the great "Unspecified Error" appeared when trying to execute the Custom Task ie objPackage.Execute.
Does anyone have any ideas why the Custom Task won't execute on MSDE? Something I missed?
May 9, 2002 at 5:55 am
Check you references to make sure it is using the right DTS component. May not be locating due to a version difference.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply