Daily Health Check fails when executing SSIS package

• eewswee

  Valued Member

  Points: 65

  More actions

  February 24, 2009 at 9:56 pm

  #126663

  I have a daily health check job set up which gathers daily information for database health check/maintenance purposes.

  The last step in the Job is to run a package.

  This package contains a data flow task with a OLE DB connection to a table containing the Daily Health job results, this is then connected to an excel destination which populates the information into an excel spreadsheet.

  This spreadsheet is then emailed.

  My issue is, that when running the package in debug mode within the BI studio the execution is successful and the excel file is created.

  When running the Daily health check JOB and coming to the last step, running the package it fails.

  Error message:

  Executed as user: IPARTPRODDB\sql_svc. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:33:30 PM Error: 2009-02-25 15:33:31.51 Code: 0xC0202009 Source: Data Flow Task Excel Destination [359] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09. End Error Error: 2009-02-25 15:33:31.51 Code: 0xC0047022 Source: Data Flow Task DTS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination" (359) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2009-02-25 15:33:31.51 Code: 0xC0047021 Source: ... The package execution fa... The step failed.

  Please help! Thank you!

  SW