Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS package with buffer issue (Sharepoint list)

Author  Topic  kjsql Starting Member 1 Post Posted - 2010-10-29 : 16:39:06 I have an SSIS package with a) Sharepoint List Source, b) Data Conversion, c) OLE DB destination. I had to use the data conversion component in order to change the string data from Unicode. All fields come over fine except for a column that basically contains some HTML code. It comes in as a 4000 character field, and I get this error even if I truncate the data in the conversion component. Here's the error: [SharePoint List Source [1]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer. at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value) at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) Here's what the data in field looks like: <div class=ExternalClass27637224667E4692AA7B7B0B2059FBE0><div id="_Note_9023a1eb-e648-4fac-aaa6-b7b5e38a628f" class="mmt_noteItem"><div class="mmt_noteHeader"><table><tr><td class="mmt_noteCreated">7/15/2010 4:03:28 PM</td><td class="mmt_noteAuthor">MEMEN What can I do to pull this over? There is some usable data in the field, and I can parse it once I get it into SQL. Do I have to add some new task to the DTS? I'm new to Integration Services... Thanks.