Sybase does not allow parameterized SQL statements. Therefore, I must build my SQL statement using Global variables. I'm new to DTS and I found the link below. What do you do with this ActiveX Script Task after it is built? How/Where do you send the recordset to be processed?

http://www.sqldts.com/default.aspx?205


' 205 (Change SourceSQLStatement)
Option Explicit

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
    Set oDataPump = oPkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

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

    ' Clean Up
    Set oDataPump = Nothing
    Set oPkg = Nothing

    Main = DTSTaskExecResult_Success
End Function




Thanks,

gmctrek