Help needed -
05-11-2004
, 05:26 AM
I had asked this question earlier earlier without adding much info. I compiles a vb6 AxticeX dll which i have used the Register Custom Task to be able to use it in my DTS. There are three parameters for the tas
Description String Feil
OrigionalFileName String Feil
NewOutputFileName String Feil
I can manuall insert the values in the DTS and it completes the task fine, however im trying to set the values from an Active x task and failing with various errors stating that the object was not fount to the object doesnt support this method
Can anybody suggest a way to set to resolve this. in this instabce if i look on the workflow properties for my task its shown a
DTSStep_ConvertFileForSQL.ClsConvert_1
Actice X cod
Function Main(
' select type of file and enable the tasks as require
dim Pk
dim stpAru
set pkg = DTSGlobalVariables.Paren
set stpAruc = pkg.steps("DTSStep_ConvertFileForSQL.ClsConvert_1" ).customtas
' ensure all steps are disable
stpAruc.DisableStep = True
' Set the required Values
stpAruc.Description = "Test File Convertor
stpAruc.OrigionalFileName = DTSGlobalVariables("gv_FileFullName").Valu
stpAruc.NewOutputFileName = "d:\temp\NEWFILE.TXT
Main = Main = DTSTaskExecResult_Succes
end function |