Step3:Set process Parameter

Function Main()

             SET cmdParameter = DTSGlobalVariables.Parent.Tasks("DTSTask_DTSCreateProcessTask_1").CustomTask
 cmdParameter.ProcessCommandLine = DTSGlobalVariables("gv_config_settings").Value

 Main = DTSTaskExecResult_Success
End Function

What actually cmdParameter  performs here and process command line? If I have to convert this script in SSIS how can I work on this? Whats the meaning of parent.tasks?

Regards

Carrick

Hi Carrick,

You can migrate that task to a script task using the DTS package migration wizard:http://msdn.microsoft.com/en-us/library/ms143496.aspx
You will need to fix your script in the migrated task however but I believe in your case it should not be too hard.
Hope this helps.