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

• Wedge78

  Ten Centuries

  Points: 1102

  More actions

  May 31, 2007 at 10:56 am

  #153610

  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