asked
SSIS package fails with error message
Hello, Job failed with below error message Executed as user: OLEX/manle_sql_prd. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:15:00 AM Progress: 2012-02-10 00:10:00.80 Source: Populate ataa from SharePoint Validating: 0% complete End Progress Error: 2012-02-10 00:10:03.96 Code: 0xC004706B Source: Populate ataa from SharePoint SSIS.Pipeline Description: "component "Health Check Data" (1)" failed validation and returned validation status " Validating: 20% complete End Progress Error: 2012-02-10 00:10:00.00 Code: 0xC004700C Source: Populate ataa from SharePoint SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-02-10 00:10:00.00 Code: 0xC0024107 Source: Populate ataa from SharePoint Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:00 AM Finished: 10:24:02 AM Process Exit Code 1. The step failed. can you please let us know the reason and remedy of the same error message.We are using sql 2008entp. thank you
Can you please give more details about your package? Moreover, Are you sure the user "OLEX/manle_sql_prd" has sufficient rights to execute the package? Does this package executes successfully in VS?
It sounds like the data structure was changed for a component that does Read / Write or a lookup. You will have to open the package up, fix the component's metadata (just double-clicking to open it should either fix or show what the errors are a suggest fixes).
4 People are following this question.
