In part of a DTS package a user will input a value. I need to take that
value and update a table. Something along the lines of

"UPDATE dbo.OLSParms" & _
" SET dbo.OLSParms.Val = '" & DTSGlobalVariables("Category").Value & "'"

From within the activex script task, how would I write this?

you can use inputBox function and catch user input to DTSGlobalVariables("Category").Value.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

I am currently using an inputbox to do this. I am new to this kind of stuff.
I am trying to actually figure out how to execute a sql string within the
activex script task.

"Bharat Jariwala" wrote:

I just was not understanding exactly how this worked before. I have since
worked throught the problem.

Function Main()
'Get Category Information
'DTSGlobalVariables("Category").Value

'Get TimeID Information
'DTSGlobalVariables("TimeID").Value
Dim oPkg, oDataPump, sSQLStatementCat, sSQLStatementTime

' Build new SQL Statement
sSQLStatementCat = "UPDATE dbo.OLS_Parms " & _
"SET dbo.OLS_Parms.Val = '" & DTSGlobalVariables("Category").Value & "' "
& _
"WHERE dbo.OLS_Parms.Parm = 'CrossAppCategory'"

' Get reference to the Exec SQL Task
Set oPkg = DTSGlobalVariables.Parent
Set oExecSQL = oPkg.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTa sk

' Assign SQL Statement to Exec SQL Task
oExecSQL.SQLStatement = sSQLStatementCat

' Clean Up
Set oExecSQL = Nothing
Set oPkg = Nothing

Main = DTSTaskExecResult_Success
End Function

Now here is my new question......
When I run this DTS package from within a SQL Job, why doesn't the input box
display?

"txksa" wrote:

Hello txksa,

It would be much better if the user deposited this value in a place that
the package could pick up rather than the package halting execution whilst
it waits for the user to enter a value.


Allan

I realized that after the fact. I have since corrected. Thank you for your
input!

"Allan Mitchell" wrote: