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

  • 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?

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

  • Thanks

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

    If I knew the column causing the error .yes

    Cheers

  • 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.

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

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