return value from ActiveX Script Task

#1

i have a DTS package that executes a JScript using the ActiveX Script task.
but how do i pass a value to this script (from SQL) and then view the return
value? or is this even possible?

basically, this JScript will encrypt a given string using MD5 encryption -
so i want to be able to pass a string to this dts task, and have it output
the encrypted version of the string.

any ideas?

tia

jt

#2

Use global variables as these can be read and written to from within
scripts.

--
Darren Green
http://www.sqldts.com

"JT" <jt (AT) nospam (DOT) com> wrote

Quote:

i have a DTS package that executes a JScript using the ActiveX Script
task.
but how do i pass a value to this script (from SQL) and then view the
return
value? or is this even possible?

basically, this JScript will encrypt a given string using MD5 encryption -
so i want to be able to pass a string to this dts task, and have it output
the encrypted version of the string.

any ideas?

tia

jt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

return value from ActiveX Script Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

return value from ActiveX Script Task - 10-19-2004 , 11:28 AM

Re: return value from ActiveX Script Task - 10-19-2004 , 12:04 PM