Idiots Guide Needed - DTS Custom Tasks

#1

Im really stuck on this and its a major part of the entire DTS. I have a task ( acticex dll written in vb6), which is registered using the register custom tasks option in the DTS Designer

I have three String ( varchar ) properties for this task ( name, infile & outfile ), which i can manually inseret data to and the task will complete fine. What i am looking to do is be able to set the properties of the 'custom' task from an ActiveX task.

Is this possible ? and if so are there any examples i can look a

Thanks for any help with this

#2

What about

dim tsk

set tsk = DTSGlobalVariables.Parent.Tasks("Name of task").CustomTask

tsk.Properties("Name of property").Value = XXXXX

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Im really stuck on this and its a major part of the entire DTS. I have a
task ( acticex dll written in vb6), which is registered using the register

custom tasks option in the DTS Designer.

Quote:

I have three String ( varchar ) properties for this task ( name, infile &
outfile ), which i can manually inseret data to and the task will complete

fine. What i am looking to do is be able to set the properties of the
'custom' task from an ActiveX task.

Quote:

Is this possible ? and if so are there any examples i can look at

Thanks for any help with this

#3

That's becausea you are specifying the name of the step

Sub

DTSStep_ConvertFileForSQL.ClsConvert_1

For

DTSTask_ConvertFileForSQL.ClsConvert_1

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Alan,

Ive tried that but keep comming up with the error that the Task was not
found.
Im not sure as to where im going wrong, if i look at the Workflow
properties of the task i get
"DTSStep_ConvertFileForSQL.ClsConvert_1"

How would i get the proper 'Task' name to ensure that im at least using
the correct details

#4

Alan

That did the trick as far as eliminating the error, but i now have a new one. on this line

tsk.Properties("Description").Value = "Hello World"

the error message = object doesnt support this property or method: tsk.Propertie

#5

Can you show me all code leading to that ?

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Alan,

That did the trick as far as eliminating the error, but i now have a new
one. on this line

tsk.Properties("Description").Value = "Hello World"

the error message = object doesnt support this property or method:
tsk.Properties

#6

do not use the second SET

i didn't

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Alan,

The Active X task is below, its one im using to try and test this problem

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function MAIN()
dim tsk
set tsk =
DTSGlobalVariables.Parent.Tasks("DTSTask_ConvertFi leForSQL.ClsConvert_1").Cu

stomTask

Quote:

set tsk.Properties("NewOutputFileName").Value = "Hello World"
Main = DTSTaskExecResult_Success
End Function

If you need the coding for the vb6 activex dll let me know

#7

it should just be

tsk.Properties("Name").Value = "Value"

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Alan,

I tried it both ways, once with the second set and once without, same
result though

object doesnt support this property or method: Set tsk.Properties

#8

can you send me your dll (zipped)

Quick one though try removing the CustomTask from the end of the task
reference

Allan

"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Alan,
i am using

tsk.Properties("NewOutputFileName").Value = "Hello World"

and still getting the same error message. I am at a loss as to why or
what to do to rectify this. Is is a SQL/DTS setup problem or a VB6 ActiveX

problem. If i submit the code would that help in tracking this down