locked
SSIS 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:21 AM

Answers

  • User-2010311731 posted

    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

    This means that you need to adjust the dataflow task for the EP_PROJECT_NUMBER column.  Either take only the first 25 characters from the source, or increase your destination field to 50 characters.

     

    Matt

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 16, 2014 10:53 AM