dbTalk Databases Forums  

DTS.Task

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


Discuss DTS.Task in the microsoft.public.sqlserver.dts forum.



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

Default DTS.Task - 08-02-2005 , 06: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.




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.