Hi,
I'm new to DTS on SQL Server7. I got this error when I ran a VB active x script in a DTS package using DTSGlobalVariables. I created the global variables. Is there a step that I missed or needed to have set up my environment to use DTSGlobalVariables? Appreciate your help.

Take a look at this http://www.sqldts.com/default.aspx?205

Thank so much for your response. I added the code (in red) to include reference to the DTSGlobalVarialbe.Parent from the example you sent but the error still remains.

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[/b]

'Original code
DTSGlobalVariables("PostDate") = month(now()) & "/" & day (now()) & "/" & year(now())
dim tmp
dim filename

tmp = right("0" & datepart("m", DTSGlobalVariables("PostDate")), 2)
tmp = tmp & right("0" & datepart("d", DTSGlobalVariables("PostDate")), 2)
tmp = tmp & datepart("yyyy", DTSGlobalVariables("PostDate"))
DTSGlobalVariables("Datestamp") = tmp
filename = DTSGlobalVariables("TransferFileNameRoot") & DTSGlobalVariables("Datestamp")
DTSGlobalVariables("TransferFilename") = DTSGlobalVariables("TransferFileDir") & "\" & DTSGlobalVariables("TransferFileNameRoot") & DTSGlobalVariables("Datestamp")


' Clean Up
Set oDataPump = Nothing
Set oPkg = Nothing
Main = DTSTaskExecResult_Success
End Function

Did you define your global variable in the package properties.

Right click anywhere on your DTS package and select "package properties", then select tab global variables

Yes, the global variables are defined. The Error Source = Microsoft VB Script runtime error.

Thanks.

Do you have any another DTS packages that work using the activex scripts? If all your activex scripts fail with this error, check and make sure you have Windows Scripting host install(WSH).

I have other DTS packages that work using active x scripts. This is the first time that I use DTSGlobalVariables. I wonder if something needs to be installed to enable using DTS global variables. But then there is a tab for Global Variables in the DTS package properties dialog box.