"Data Transformation Services. MSDE 2000 is capable of running Data Transformation Services (DTS) packages. However, it cannot design DTS packages, because it is not equipped with a DTS Designer."
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.
A 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 but is ok in my development IDE?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.