locked
connection Error RRS feed

  • Question

  • User310637483 posted


    Message
    Executed as user: NDPINNACLE\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 3:00:00 PM Progress: 2014-01-16 15:00:01.84 Source: Classification Validating: 0% complete End Progress Progress: 2014-01-16 15:00:01.84 Source: Classification Validating: 50% complete End Progress Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification OLE DB Destination [239] Description: Truncation may occur due to inserting data from data flow column "EP_PROJECT_NUMBER" with a length of 50 to database column "EP_PROJECT_NUMBER" with a length of 25. End Warning Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification OLE DB Destination [239] Description: Truncation may occur due to inserting data from data flow column "OPERATION_MODE" with a length of 50 to database column "OPERATION_MODE" with a length of 10. End Warning Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification OLE DB Destination [239] Description: Truncation may occur due to inserting data from data flow column "RECORD_STATUS" with a length of 50 to database column "RECORD_STATUS" with a length of 1. End Warning Progress: 2014-01-16 15:00:03.23 Source: Classification Validating: 100% complete End Progress Progress: 2014-01-16 15:00:03.24 Source: Keymembers Validating: 0% complete End Progress Progress: 2014-01-16 15:00:03.24 Source: Keymembers Validating: 50% complete End Progress Error: 2014-01-16 15:00:12.60 Code: 0xC0202009 Source: PINNORA_PROJECTS_PHASE1_2 Connection manager "HSOracleERP_EPIFACE" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12537: TNS:connection closed ". End Error Error: 2014-01-16 15:00:12.60 Code: 0xC020801C Source: Keymembers OLE DB Destination [997] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "HSOracleERP_EPIFACE" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-01-16 15:00:12.60 Code: 0xC0047017 Source: Keymembers SSIS.Pipeline Description: component "OLE DB Destination" (997) failed validation and returned error code 0xC020801C. End Error Progress: 2014-01-16 15:00:12.60 Source: Keymembers Validating: 100% complete End Progress Error: 2014-01-16 15:00:12.60 Code: 0xC004700C Source: Keymembers SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2014-01-16 15:00:12.60 Code: 0xC0024107 Source: Keymembers Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:00:00 PM Finished: 3:00:12 PM Elapsed: 12.402 seconds. Process Exit Code 1. The step failed.

    Thursday, January 16, 2014 9:20 AM

All replies

  • User269602965 posted

    you are trying to insert data that is wider than the target column allows.

    Saturday, January 18, 2014 2:54 PM