error :Column data type DT_STR is not supported by the PipelineBuffer class.

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  September 20, 2012 at 2:08 am

  #268007

  I'm moving some data from sql server table to shaepoint list.

  I'm on sql server 2008 r2

  The input columns from sql serer table shows DT_STR and the Avalabe dest(sharepoint) list was showing DT_WSTR

  and when i ran the job it complained of DT_WSTR so i changed the columns it to DT_STR

  and now getting error.

  Error: 0xC0047062 at Data Flow Task, SharePoint List Destination 1 [10095]: Microsoft.SqlServer.Dts.Pipeline.UnsupportedBufferDataTypeException: Column data type DT_STR is not supported by the PipelineBuffer class.

  The messy thing it doesn't actually tell you the colum you have problem with.Even if i look at the SSIS logging

  Any ideas?

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  September 20, 2012 at 2:13 am

  #1539926

  Have you tried to use a data conversion task instead of just changing the column types?

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  September 20, 2012 at 4:40 am

  #1539989

  Thanks

  But are you saying I should just use data conversion for every column?

  If I knew the column causing the error .yes

  Cheers

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  September 20, 2012 at 4:48 am

  #1539995

  If the source is Non-Unicode and the destination is Unicode it is best to stick a data conversion task in to convert the data from Non-Uni to Uni (or vice-versa) for every column which violates the Non-Uni to Unicode mapping.