SP LIST DESTINATION - don't inserting float value

Sep 8, 2009 at 8:53 AM

Hi, ALL!

I have SQL table with many text fields and field SPENDHOURS - it is float, and I have SP List with same names and types of fields.I use SharePoint List Destination for newlines from SQL tables in the list. All fields are transferred correctly, but the field of type float - not tolerated. Error SSIS package does not allow, the SP too, no errors.
What to see?
Mapping field is set up correctly ...Locales of SQL Server with SP DB - Russian, SP Site language is Russian, proprties SharepointCulture is "ru-RU"...

Sep 29, 2009 at 5:52 AM

It doesn't like your float? Does it just ignore it?  Sorry, I do not have much experience in the russion edition of sql or SP.  Does anyone else have that combination who might be able to debug? I'd be happy to make an update if someone finds something I should change.

 

Sep 29, 2009 at 7:00 AM
I solved the problem as follows: float value from SQL table i cast to the type nvarchar - and the list is filled correctly.
Probably, somewhere is not working casts in different locales ...
Otherwise, everything's just fine!
Thanks for the nice tool!