Re: DTS Scheduled Job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

well to answer your original psot, you must troublshoot your step sto make
sure the final one returns normaly.

Some things you can do.

log what the value of <strZipCmd = "wzunzip -c -o " & strZipDir &
DTSGlobalVariables("ZipFile").value & " " & strDestDir> ends up being
execute the script as a vbscript with the credentials of the Agent account
using runass

or run the command from the command line using you credentials
make sure the command executes and returns normaly

make your script write the command output to a file...

just do some normal troublshooting to determine where it fails...

The reason your job never finishes is because your final step is not
returning normaly.....you can use taskmon or procmon from sysinternals to
see if wzunzip is still running after you think it is done....etc

this help any ?

"Kibagami23" <kibagami23@xxxxxxxxx> wrote in message
news:1130785532.469022.319660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thank you for the prompt answer, yes it is a cmd exec,the last task of
> the package is to extract a zipped file into a folder (using wzunzip),
> by the way that is another problem, according to the job everything
> finishes ok, but it doesn't extract the file (the error on that task
> is "End of central directory signature not found, the file is not
> recognazible" or something like that but the main poroblem here is that
> it doesn\t recognize the ".Z' extension of the file, but if i extract
> the file manually it does extract it, any ideas on this one?), the
> steps on the package are:
>
> Activex Script Task (to generate todays value onto a global variable)
> Dynamic task properties (to update the globalvariable)
> File Transfer Protocol Task (to get the zipped file from the FTP
> server)
> Activex Script Task (to extract the file using wzunzip)
>
> This is the command on the last script:
> strZipCmd = "wzunzip -c -o " & strZipDir &
> DTSGlobalVariables("ZipFile").value & " " & strDestDir
>


.

Relevant Pages

  • CGIscript.net - csMailto.cgi - Remote Command Execution
    ... CGIscript.net - csMailto.cgi - Remote Command ... csMailto is a perl cgi formmail script developed by ... execute command on server and mail output to anyone ...
    (Bugtraq)
  • Re: shell scripting
    ... and am assuming an sh-compatible shell here.... ... command 1 options arguments ... To run the script, do: ... then you need to use the full path to execute it: ...
    (comp.unix.questions)
  • Re: shell scripting
    ... and am assuming an sh-compatible shell here.... ... command 1 options arguments ... To run the script, do: ... then you need to use the full path to execute it: ...
    (comp.unix.shell)
  • Problems using Expect to parse a file
    ... I'm trying to write a script to automate a program called DeltaE, a powerful thermoacoustic design tool, and to extract performance data from the simulations it runs by parsing through its output files. ... Less, on the other hand, remains open upon reaching the end of a file until it receives the "q" command, so I tried writing a script to step through the file using that, as follows: ... The trouble now is, although manually executing the command "less -c data/1.out" at a tty functions just as you would expect it to, when Expect sends the exact same command as part of the spawn process, and running the script with exp_internal true, apparently none of the data sent to the display by less when started normally is being seen by Expect - all it seems to get is "No tags file\r\n", followed by eof and closure of Less - I'm afraid I haven't a clue what the "No tags file" statement means. ...
    (comp.lang.tcl)
  • =?iso-8859-1?Q?Re:_Jcl?=
    ... I can send you a program that you execute as a step in your job and it ... I have a command and job scheduler that is available in a free version ... demand script processor with the full scripting ability so that your job ...
    (bit.listserv.ibm-main)