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.

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 (AT) yahoo (DOT) com> wrote

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.