<GregToro...@discussions.microsoft.com> wrote:
> Hi there...
>
> I'm fairly new to SSIS, and am having an interesting issue.
>
> I have a fairly standard package, it:
> - Imports a table
> - Runs a query
> - Exports a Flat File
> - Zips the flat file using a comand line process
> - FTP's that File to my server.
>
> If I run the package in debug mode within Visual Studio, I have no problems
> - it runs successfully.
>
> I can save, build and deploy the package itself - no errors.
>
> I can manually run the dtsx file using the Execute Package Utility - no
> problems.
>
> If, however, I try to schedule the job using the SQL Server Agent, I get an
> error. No specific error - just "job failed, check log", and the log simply
> says the SSIS package failed.
>
> Playing around with it, it seems to be the Winzip and FTP jobs that fail...
> I can schedule an import, an export, etc.
>
> Any ideas where i can look?
>
> Many thanks...

wrote:
> Hi there...
>
> I'm fairly new to SSIS, and am having an interesting issue.
>
> I have a fairly standard package, it:
> - Imports a table
> - Runs a query
> - Exports a Flat File
> - Zips the flat file using a comand line process
> - FTP's that File to my server.
>
> If I run the package in debug mode within Visual Studio, I have no problems
> - it runs successfully.
>
> I can save, build and deploy the package itself - no errors.
>
> I can manually run the dtsx file using the Execute Package Utility - no
> problems.
>
> If, however, I try to schedule the job using the SQL Server Agent, I get an
> error. No specific error - just "job failed, check log", and the log simply
> says the SSIS package failed.
>
> Playing around with it, it seems to be the Winzip and FTP jobs that fail...
> I can schedule an import, an export, etc.
>
> Any ideas where i can look?
>
> Many thanks...