Is there an env var or property that tells me if I have been run from
Enterprise Manager of from DTSRun (e.g. scheduled).
If I have been run from the GUI I can request input, or show errors in an
activex, but if not, I would want to quit immediately.
--
Thanks and Good Luck.
Fergus

Hello Fergus,

Once the package is loaded up there is no way from within DTS to tell how
you was executed AFAIK. DTS is one of those apps where I never think it
good to request user input. A lot of the uses for DTS are scheduled and
unattended so asking the user to enter something in a box will probably not
work very well.

Try having the user enter the values for the scheduled running into an external
medium that can be read by the Dynamic Properties Task.

To see what errors have occured you should enable logging.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks, I agree that I don't want to be doing UI stuff in a scheduled DTS job.
However, in another response (to IMcphee) you had written:
"You pass in the connection info to the package on the cmdline using DTSRun."
How would I do this? I was under the impression that DTSRun could not pass
anything to a package.
--
Thanks and Good Luck.
Fergus



"Allan Mitchell" wrote:

Hello Fergus,

Have a look at the /A switch. It allows you to set GV values from the cmd
line


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com