> 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.
> "Allan Mitchell" wrote:
>
>> 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
>>> 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