dbTalk Databases Forums  

CustomTask & SQL Server SP4

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss CustomTask & SQL Server SP4 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
headsea
 
Posts: n/a

Default CustomTask & SQL Server SP4 - 06-14-2005 , 01:18 AM






When I packaged SP4, code below will occure an error, however, before SP4, it
works well. I assume there is any change for Object Modal in SP4.

Dim oPackageOld As New DTS.Package
Dim oPackage As DTS.Package2
Set oPackage = oPackageOld
............
Dim oTask As DTS.Task
Dim oCustomTask1 As DTSOlapProcess.Task
Set oTask = DTSPackage.Tasks.New("DTSOlapProcess.Task")
oTask.Name = "DTSTask_DTSOlapProcess.Task_1"
Set oCustomTask1 = oTask.CustomTask
oCustomTask1.Name = "DTSTask_DTSOlapProcess.Task_1"

When run over "Set oCustomTask1 = oTask.CustomTask", an error ‘Type
mismatch’ will popup. Anyone can help me?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.