I am thinking of using DTS to runs several tasks in
parallel by creating task dynamically from a package. The
task should execute store procedure include sever
parameters. Should it be custom task and how do I
execute the task as I create them, any example will be
appreciated.

Hi Allan,

I am trying to run several tasks in parallel and I thought
DTS’s tasks are the ideal implementation. Your example
seems to support it,

sSQLStatement = "SELECT TOP 1 FROM dbo.employee WHERE
hire_date > '" & _
DTSGlobalVariables("HireDate").Value & "'"

' Get reference to the DataPump Task
Set oPkg = DTSGlobalVariables.Parent
FOR I = 1, 4
Set oDataPump = oPkg.Tasks
("DTSTask_DTSDataPumpTask_1").CustomTask

' Assign SQL Statement to Source of DataPump
oDataPump.SourceSQLStatement = sSQLStatement
‘ Can I execute here??
' Clean Up
Set oDataPump = Nothing
Set oPkg = Nothing


'Udpdate dbo.employee ....
Update dbo.employee ...
NEXT

Is this will excute in threads?

Ahmed.

This is closer to what I want to do:
Function Main()
Dim oPkg, oDataPump, sSQLStatement

' Build new SQL Statement
sSQLStatement = "SELECT * FROM dbo.employee WHERE
hire_date > '" & _
DTSGlobalVariables("HireDate").Value & "'"

' Get reference to the DataPump Task
Set oPkg = DTSGlobalVariables.Parent

For I = 1, 4
Set oDataPump = oPkg.Tasks
("DTSTask_DTSDataPumpTask_" & I).CustomTask

' Assign SQL Statement to Source of DataPump
oDataPump.SourceSQLStatement = sSQLStatement

'Do I need an execute here?
' Clean Up
Set oDataPump = Nothing
NEXT
Set oPkg = Nothing

Main = DTSTaskExecResult_Success
End Function