New to DTS

[gmctrek]

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? I understand the code until you get to: "Get reference to the DataPump Task." Should I build a Data Transformation Task and call it "DTSTask_DTSDataPumpTask_1".

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

 

[DataLWalker]

gmctrek,

In case you have not yet been answered on this one.

You will need to assign the "HireDate" Global Variable using the Dynamic Properties Task before you run this ActiveX code.

The "DTSTask_DTSDataPumpTask_1" Task is created as a CustomTask when you "Set oDataPump = ...".


HTH,
DataLWalker