Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Custom Task execution prob in MSDE.

Status
Not open for further replies.
LotusEater

LotusEater

Programmer
May 8, 2002
5
0
0
AU

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 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?
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
119
SaltyTheFrog
SaltyTheFrog
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
86
Auguy
Auguy
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
139
Auguy
Auguy
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top