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