Sharepoint list destination error
Encounter the below error in ssis etl when inserting data from database table to a Sharepoint list using Sharepoint List Destination tool. Microsoft.SqlServer.Dts.Pipeline.UnsupportedBufferDataTypeException: Column data type DT_UI1 is not supported by the PipelineBuffer class.
May 18th, 2012 11:29am

Just change the datatype to something else using the Data Conversion TransformArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 11:42am

Hi, The data type in database table is tinyint and I used data conversion to convert it into numeric and the error stopped coming but the value of the column on which i applied data conversion did not got transferred. Blank value is getting displayed in the sharepoint list under the converted column.
May 18th, 2012 1:31pm

Do not use Numeric, just use DT_I4Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 1:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics