reading contents of an activexscript using DTS objects in vb

#1

I'm using VB6 and SS2000. I'm searching for a table name and I want to
search in the actual script in a DTSActiveScriptTask object. I can see the
name of the script and the description but is there a way to actually see
the script itself? There must be since it is stored somewhere. What object
is it?

Thanks,

Dan

#2

The Script itself is the ActiveXScript property of the Task object

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dan" <ddonahue (AT) archermalmo (DOT) com> wrote

Quote:

I'm using VB6 and SS2000. I'm searching for a table name and I want to
search in the actual script in a DTSActiveScriptTask object. I can see the
name of the script and the description but is there a way to actually see
the script itself? There must be since it is stored somewhere. What object
is it?

Thanks,

Dan

#3

That's so cool. Thanks.

Dan

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The Script itself is the ActiveXScript property of the Task object

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dan" <ddonahue (AT) archermalmo (DOT) com> wrote in message
news:uq8AOFfMEHA.2628 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
I'm using VB6 and SS2000. I'm searching for a table name and I want to
search in the actual script in a DTSActiveScriptTask object. I can see
the
name of the script and the description but is there a way to actually
see
the script itself? There must be since it is stored somewhere. What
object
is it?

Thanks,

Dan

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

reading contents of an activexscript using DTS objects in vb

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

reading contents of an activexscript using DTS objects in vb - 05-04-2004 , 10:55 AM

Re: reading contents of an activexscript using DTS objects in vb - 05-04-2004 , 11:15 AM

Re: reading contents of an activexscript using DTS objects in vb - 05-04-2004 , 12:51 PM