I had exactly same prob. Spent 3 months writing elaborate VB DTS Custom Task under SQL Server 7.0 only to find it wouldn't run when deployed on user's machine. Experimented with a 'virgin' machine under MSDE (no go) and then SQL Server Desktop Engine (SQL Server with no Client Tools) ok. Now...
DTS Objects in use:
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...
Custom Task execution prob in MSDE.
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...
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.