sql server dts: Cannot run command in DTS -- sql server dts

Cannot run command in DTS

MA
3/14/2005 1:06:10 PM

sql server dts:

From within a DTS pacakge ActiveX script I'm building a
command with a .cmd extension and then trying to execute
the command via shell.run. I've installed this successfully
on 10 servers so far without a problem. On server 11 the
process is hanging after the command file is created. When
I execute the task from within the DTS package I get the
following message in a popup: Some files can harm your
computer. If the file information below looks suspicious,
or you do not trust the source, do not open or save this
file. It then lists the file information and a warning
about malicious code. We have the option to save or open
the file. I've tried running this with domain admin
credentials.

Question 1: Is there a secure way to allow .cmd files to be
run?

Question 2: Is there a way to turn off the prompting and
make it default to 'open'?

Question 3: Is there something I can do via user/group

Cannot run command in DTS

MA
3/15/2005 8:45:22 AM

I resolved the issue with the popup by changing some
security setting in IE. My script now runs until the .cmd
file is created but hangs at that point. It never executes.
This only happens when I'm running the dts via a job. If I
execute the script from within the package it works fine.

Any help or suggestions would be appreciated.
Thanks...
MA
[quoted text, click to view]

Re: Cannot run command in DTS

Simon Worth
3/15/2005 3:05:57 PM

Check the log history to see if it points to anything, also check the event
logs to see if popups were encountered. it will hang on popups if run
through a job. Also, what context is the job being run in - I mean to say,
what user is the job being executed under. Changing IE settings may only be
for you, not the context of the job user running the job.

--
Simon Worth

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.