export to xlsx column having > 255 char length

• polkadot

  SSChampion

  Points: 13664

  More actions

  March 15, 2019 at 12:33 am

  #416875

  moving just one column from sql table to excel, specifically the one column > 255 char length.   getting error.
  can limitation be overcome with SSIS VS 2013?

  source: sql table
  destination: xlsx

  data flow
  1. ole db source  (column varchar(8000))
  2. data conversion (column Unicode string [DT_WSTR] length 4000 is max allowed)
  3. excel destination (column General)

  [Excel Destination [12]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
  An OLE DB record is available.  Source: "Microsoft Access Database Engine"  Hresult: 0x80040E21  Description:
  "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.".

  [Excel Destination [12]] Error: There was an error with Excel Destination.Inputs[Excel Destination Input].
  Columns[Copy of materialdescription_ups] on Excel Destination.Inputs[Excel Destination Input]. The column status returned was:
  "The value violated the schema's constraint for the column.".

  [Excel Destination [12]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Excel Destination.Inputs[Excel Destination Input]" failed because error code 0xC0209076 occurred,
  and the error row disposition on "Excel Destination.Inputs[Excel Destination Input]" 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.

  --Quote me