Thanks to a lot of help and time put in by Allen, ive managed to get to the stage where i have an ActiveX task setting the properties for a custom task ( written in VB 6 ).

The cystom task is set to disabled, and im using the ActiveX task to set the thw file names and set the step te disabled = false. In the DTS designer i right hand click the ActiceX task an execute step with no errors. After checking the properties of my custom task i can see that the file names have been set and the disable step is no checked. However when i try and execute the DTS i get the following error on the ActiveX task at tthe point it tries to set the 1st file nam

execption_Access_violatio

the activex task is as follow

Function Main(
' select type of file and enable the tasks as require
dim pk
dim ts
dim stpSetTas
dim stpCustDll

set pkg = DTSGlobalVariables.Paren
set stpSetTask = pkg.Steps("DTSStep_DTSActiveScriptTask_7")
set stpCustDll = pkg.steps("DTSStep_ConvertFileForSQL.ClsConvert_1"
set tsk = DTSGlobalVariables.Parent.Tasks("DTSTask_ConvertFi leForSQL.ClsConvert_1"

tsk.Properties("OrigionalFileName").Value = DTSGlobalVariables("gv_FileFullName").Valu
tsk.Properties("NewOutputFileName").Value = DTSGlobalVariables("gv_TempFile").Valu

stpCustDll.DisableStep = Fals
stpSetTask.DisableStep = Fals
stpCustDll.ExecutionStatus = DTSStepExecStat_Waitin

Main = DTSTaskExecResult_Succes

End Functio

Any pointers on where to look ?

Make sure the ActiveX Script Task is set to execute on main thread, as found
on the same sheet as the Disable Step option.


--
Darren Green
http://www.sqldts.com

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

task ( written in VB 6 ).
i right hand click the ActiceX task an execute step with no errors. After
checking the properties of my custom task i can see that the file names have
been set and the disable step is no checked. However when i try and execute
the DTS i get the following error on the ActiveX task at tthe point it tries
to set the 1st file name