Issue with SharePoint List Source and numeric value (float)

Oct 7, 2009 at 3:51 PM

Hi,
I try to use "SharePoint list Source" adapter with SSIS on SQL Server 2008 SP1 and I have this error message :
[SharePoint List Source [1]] Erreur : « System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket) »


I seek the problem on Sharepoint field with decimal value like currency or float type.

Can you help me please.

Thanks

Laurent