SSIS failing with UTF-16BE and UTF-16LE log files

  • HI

    I am trying to execute an SSIS package to import data into a table with the following columns:

    [ROWID],[IPID],[MD5],[Keyfile],[Text],[length]

    When the log file is in unicode 8 it imports fine but I need UTF-16LE to work. I have tried UTF-16BE but it also fails

    The error that is output is:

    [Flat File Source [2700]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "output column "Length" (2733)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "Length" (2733)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

    Any help would be greatly appreciated

    thanks

    Chris

     

     

     

     

Viewing post 1 (of 1 total)

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