Error : Data Conversion Failed


  • Hello All,

    I  have a package which imports data into SQL server 2005 table (say PRODUCT) using 3 CSV files(say A,B,C).
    I have a column 'DESCRIPTION' in the table, which uses two CSV files A & B.
    Data type and the size of the column in the two sources (CSV files A & B) are string [DT_STR],1024.
    And in the Table PRODUCT , it is varchar(1024).

    When i try to run the package,it is giving the error as below:

    [Flat File Source REQ_FILE [8144]] Error: Data conversion failed. The data conversion for column "DESCRIPTION" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
    [Flat File Source REQ_FILE [8144]] Error: The "output column "DESCRIPTION" (13691)" failed because truncation occurred, and the truncation row disposition on "output column "DESCRIPTION" (13691)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
    [Flat File Source REQ_FILE [8144]] Error: An error occurred while processing file "E:\DOCSS\LOAD\_REQ_FILE.csv" on data row 65.

    I am new to the SSIS.
    If you have any thoughts on this,Please let me know.

    miércoles, 21 de octubre de 2009 11:36

Todas las respuestas