Post reply

Error at Data Flow Task [Flat File Destination [4165]]: The data type for "input column "Reason" (5098)" is DT_NTEXT, which is not supported with ANSI files

  • August 15, 2011 at 1:54 am

    #241764

    Hi All,

    I'm hoping to get help from here.

    I'm trying to load some data from Sharepoint list to an excel using SSIS.

    First i tried Excel Destination with no luck then i decided to try Flat File Destination.

    But i keep getting error on just one particular column which is a multiple line of text in SharePoint.

    This is the error i get below:

    Error at Data Flow Task [Flat File Destination [4165]]: The data type for "input column "Reason" (5098)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.

    Error at Data Flow Task [DTS.Pipeline]: "component "Flat File Destination" (4165)" failed validation and returned validation status "VS_ISBROKEN".

    Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

    Error at Data Flow Task: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    I tried changing DT_NTEXT to D_DSTR but still no luck.

    Any ideas would be appreciated.

    Thanks

  • August 15, 2011 at 11:18 am

    #1368749

    Did you try changing DT_NTEXT (UNICODE Stream), to DT_TEXT (Text Stream) ?

  • August 15, 2011 at 8:22 pm

    #1368919

    Tried that and no error but the data in the colum didn't export.

    But usin Derrived column and converting to DT_WSTR worked

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

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