tags:

views:

218

answers:

1
Q: 

SSIS- Sharepoint list data transfer issue

Hi ,

We are trying to transfer data from oracle database (about 60,0000) records only to a sharepoint list using SSIS. But we are getting following error when records reaches around 19000 . The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020 and System.ServiceModel.ProtocolException: The remote server returned an unexpected response: (400) Bad Request.

Earlier we thought if could because of Sharepoint list limit so we tried by reducing two of the columns and then it has went fine.

So we left with one of the column of Datatype DT_STR and length 400 in oracle beacuse of which issue might be happening, It is mapped to sharepoint custom list field of multiline type.

We also verified if length of field is issue but in oracle DB for all records max length for this column is only 239 so length issue is also ruled out.

Any one who has faced this kind of issue or knows cause of this issue.Kindly let us know..

Thanks and regards,

Vicky

A: 

May be this can help.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c8090eb5-654b-4e6d-a8c2-29fb3cedaa43

hemalshah  2009-10-01 21:13:17
Nopes, We found that issue is because of special characters in source column which Sharepoint list is not accepting through web service call.
Vicky  2009-10-03 16:37:55

related questions

Upgrading Sharepoint 3.0 to SQL 2005 Backend?
Webpart registration error in event log
Sharepoint COMException 0x81020037
Transactional Design Pattern
Deploying InfoPath forms to different SharePoint servers
Profiling/Optimizing (Sharepoint 2007) Web Parts
Retreiving the PC Name of a Client? (Windows Auth)
What's the best way to report errors from a SharePoint workflow?
How to get out parameters working in SharePoint workflows
Editing User Profile w/ Forms Authentication
WSS/MOSS Book
Creating a development environment for SharePoint.
Sharepoint Wikis
Have you used a wiki in your project or group?
Can I copy files to a Network Place from a script or the command line?
How do you deploy your SharePoint solutions?
SharePoint WSS 3.0 Integration with Mac OSX (either Safari or Firefox)
SharePoint - Connection String dialog box during FeatureActivated event
How can I improve the edit-compile-test loop when developing a SharePoint workflow?
Best ajax library for Sharepoint
Alternative Hostname for an IIS web site for internal access only
How to reference to multiple version assembly
MOSS SSP problem - Failed database logons from deleted SSP
Sharepoint: executing stsadm from a timer job + SHAREPOINT\System rights
Can ASP.NET AJAX partial rendering work inside a SharePoint 2007 application page?