locked
Error on Trying to Execute the SSIS Job RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Executed as user: domail\user . ...on 9.00.5000.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:30:13 AM  Error: 2012-01-09 02:35:50.96     Code: 0xC0202009     Source: Load Assessor History OLE DB Source [1]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Syntax error, permission violation, or other nonspecific error".  End Error  Error: 2012-01-09 02:35:50.97     Code: 0xC004706B     Source: Load Assessor History DTS.Pipeline     Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2012-01-09 02:35:50.97     Code: 0xC004700C     Source: Load Assessor History DTS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2012-01-09 02:35:50.97     Co...  The package execution fa...  The step failed.
    Monday, January 9, 2012 8:20 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    This message comes when there is change in Metadata what defined in package.

    Just Compare the OLE DB Source Metadata and table Metadata and refresh if its changed and try to re-execute package.

    Shailesh, Please mark the post as answered if it answers your question.
    • Marked as answer by Eileen Zhao Tuesday, January 17, 2012 3:12 AM
    Monday, January 9, 2012 8:25 AM