MSDE DTS

[Ladyhawk]

I am having some problems using DTS with an MSDE database. Does anyone know if MSDE is capable of DTS? Ladyhawk.
** ASP/VB/Java Programmer **

 

[tlbroadbent]

"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."

Source:

http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

Check the following article:

http://www.swynk.com/friends/sharma/MSDE.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[LotusEater]

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 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?

Brian