Post reply

Getting truncation errors while Importing Unicode from Excel sheet using SSIS

  • December 26, 2009 at 2:28 am

    #217855

    While importing excel sheet in SQl server I am getting truncation errors.

    The data I am given in sheet is Unicode string and for some cell size data is more than 255 charecters. The text is as below mentioned. Select all from 1 to end and paste in excel sheet. It will create two columns, the problem is with text column which is giving truncation error for unicode charecter size more than 255 charecters.

    Sample Data

    ===========

    1in open not submitted for ghfgdhgfhdgf tertet notwetwet as per email from abc on oct 11; updated in some axssd site

    2in open not submitted for ghfgdhgfhdgf tertet notwetwet as per email from abc on oct 11; updated in some axssd site

    3in open not submitted for ghfgdhgfhdgf tertet notwetwet as per email from abc on oct 11; updated in some axssd site

    4is given completey rtertert rtvrtyrete tytyrty # 1257

    5is given completey rtertert rtvrtyrete tytyrty # 1257

    6in open not submitted for ghfgdhgfhdgf wom4 number as per email from abc on oct 11; updated in some axssd site

    7in open not submitted for ghfgdhgfhdgf qw number as per email from abc on oct 11; updated in some axssd site

    8confirmed by mr Great - on Dec 30

    9as per my certificatel dt Fe 11; Only dfdkfj is given for the total amt agst dfdkfjdfd # 1400; updated in measurement site

    10dfsdfsdfsd fvgf cfdfgfdgdft is given completey agst lrlfdsfd # 54//INF152188//Some charges for UYT ddffaerts-CS Upgrade for Feb08//Also attached is the jdgfdjf gdfgrfgit for $788,000, fglfgf fglkgflg fggfgf fgfgf fgdfgfd fgfdgd $4,500 and the balance fgdfgdfg fgdfgdfg of $5,500 will be fgfgdf fgdfgdf the gfhfghfgh fghfghfg fgfgdf fgfg dfggf dfgg.

    11dfsdfsdfsd fvgf cfdfgfdgdft is given completey agst lrlfdsfd # 54//INF152188//Some charges for UYT ddffaerts-CS Upgrade for Feb08//Also attached is the jdgfdjf gdfgrfgit for $788,000, fglfgf fglkgflg fggfgf fgfgf fgdfgfd fgfdgd $4,500 and the balance fgdfgdfg fgdfgdfg of $5,500 will be fgfgdf fgdfgdf the gfhfghfgh fghfghfg fgfgdf fgfg dfggf dfgg.

    Thanks In Advance for help.

  • December 26, 2009 at 2:33 am

    #1096514

    The sample excel file is also attached for refrence.

  • June 10, 2010 at 10:54 am

    #1178767

    If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

    * Excel Source component - for reading data from Excel worksheet.

    * Excel Destination component - for writing data in Excel worksheet.

    * Excel Task - for manipulating Excel workbooks.

    * Excel Connection - used by the components above and also for implementing custom scripts based on it.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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