I would like to know, from an ActiveX script task within a running package,
if the package is running batch (scheduled) or if it was launched by the
user (using the Execute Package at the UI).

is this possible ?

my objective is that this ActiveX script sets default values for the package
when it is run disattended, but if it is run interactively it should ask the
user for that values.

thanks in advance,
ant.

You won't know from inside the package as all it knows is that you asked it
to go

Saying that though you may like to add a parameter to the package that you
populate with a given value if run from a job and something else or blank
when run interactively. This way you can then test the value in the package
and use workflow to determine what happens in the package

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Antonio Lopez Arredondo" <adog (AT) someplace (DOT) com> wrote