Is anyone aware of a reference guide for ActiveX scripting
within DTS, Specifically, creating and calling objects and
any limitations thereof.

Jeff <Georgejt (AT) hotmail (DOT) com> wrote:
You will find all about scripting under:
www.microsoft.com/scripting

kind regards

Frank
www.xax.de

In article <070701c377ae$b03ba6a0$a001280a (AT) phx (DOT) gbl>, Jeff
<Georgejt (AT) hotmail (DOT) com> writes
Nope.

You can do pretty much anything in the standard ActiveX Script language,
although I'm not sure of good "standard" reference.

There are also some extra objects in the DTS flavour, such as
DTSGlobalVariables for example. These are covered in "DTS Scripting
Reference"
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books
\dtsprog.chm::/dtspscrobj_3xr9.htm).

There are plenty of samples around such as in Books Online, the archives
for this newsgroup and of course (http://www.sqldts.com).

If it is an object and it implements the proper COM interfaces for a
class then you can use it. Only example I can think of where this cannot
be done (and I have wanted to) is the WScript.Sleep funtion, because
WScript is sort of like and implicit object in WSH, similar to
DTSGlobalVariables in the DTS host.

Any questions, then here's the place to ask.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org