DTS.Task -
08-02-2005
, 05:01 PM
We had a program running perfectly fine and one of our users upgraded to sql
sp4 and now we get an error that o.task can not be initialized .
first we
Set oTask = goPackage.Tasks.New("DTSOlapProcess.Task")
then We declare an object reference as "Dim oCustomTask1 as
DTSOlapProcess.Task". Later in the function we attempt to initialise the
object viz "Set oCustomTask1 = oTask.CustomTask' where oTask has been
previously declared as 'Dim oTask as DTS.Task".
This is fine with SP3, no issues whatsoever but the "Set" assignment fails
with SP4. |