Post reply

data truncation error-please suggest

  • March 23, 2016 at 10:54 am

    #326013

    hi all

    i need suggestion on this error

    Truncation may occur due to inserting data from data flow column "name"

    with a length of 50 to database column "name" with a length of 10.

    i understand there is some error with name column ,

    tyring to load data from text file to sql using ssis.

    text file data:

    id,name ,salary

    1,Steve,20000

    2,rahul,3000

    3,rita,4000

    Destination file:

    create table customertax

    (custid int,name varchar(10),salary int,tax int)

    Please find the attachment

  • March 23, 2016 at 11:11 am

    #1867176

    db8 (3/23/2016)

    hi all

    i need suggestion on this error

    Truncation may occur due to inserting data from data flow column "name"

    with a length of 50 to database column "name" with a length of 10.

    i understand there is some error with name column ,

    tyring to load data from text file to sql using ssis.

    text file data:

    id,name ,salary

    1,Steve,20000

    2,rahul,3000

    3,rita,4000

    Destination file:

    create table customertax

    (custid int,name varchar(10),salary int,tax int)

    Please find the attachment

    Suggestions:

    1) Change length of name column in SSIS package to 10

    2) Increase length of name column in SQL Server

    And lastly, this message is usually a warning rather than an error. Your package would still run ... until a name with more than 10 characters comes through.

  • March 23, 2016 at 11:17 am

    #1867178

    thankyou sir, for the suggestion got it..

    🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply