Re: Package fail on unzip file step...
- From: "Narayana Vyas Kondreddi" <answer_me@xxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 15:52:59 +0100
When you ran it interactively, the unzip program is invoked on your machine.
But as a job, it is invoked on the server. So have you made sure unzip
command line is setup on the server also?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Nestor" <n3570r@xxxxxxxxx> wrote in message
news:ukzBaOEPFHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
I have a DTS package that is designed to download files from a FTP server
and then unzip the files into a pacticular folder. The strange thing is that
if I where to run the package manually it works but if i schedule it to run
periodically it'll fail on the unzip file step.
I basically used the ActiveX task to unzip the file using Winzip cmd line
commands.
Below is the script that goes into the unzipping step
dim WshShell
dim UnzipString
Set WshShell = CreateObject("WScript.Shell")
UnzipString = "%Unzip% -d " & DTSGlobalVariables("StorePath").Value & "\" &
DTSGlobalVariables("ZipFile").Value & " " &
DTSGlobalVariables("XMLPath").Value
WshShell.Run UnzipString,,true
What's puzzling me is why is the package failing only if i scheduled it to
run periodically but not when i run it manually? I'm aware there're some
problems with DTS permission when scheduling the package to run, but if
that's the reason shouldn't the package failed totally instead of just
failing on that step?
Any help will be appreciated. Thanks in advance.
.
- References:
- Package fail on unzip file step...
- From: Nestor
- Package fail on unzip file step...
- Prev by Date: Re: How to using query to replicate table ?
- Next by Date: DTS Package fails when run as a job (not usual permissions issue)
- Previous by thread: Package fail on unzip file step...
- Next by thread: DTS Package fails when run as a job (not usual permissions issue)
- Index(es):
Relevant Pages
|
