I am using SSIS to pull a list from our production database to get a list of names and compare it to a list in sharepoint, then update the sharepoint list with any new names. Right now what I have working is a lookup transformation from our production database
to the sharepoint database and an output file destination to put all the new names in.
so it looks something like this in my data flow....
get production data -> convert it so it matches sharepoint data types ->lookup the values in sharepoint and compare them to production ->output any names that don't match to an excel file.
This works great!
here's what I need to do...
Once I get the new names, I need to insert the new names back into the sharepoint list. I have been testing the Proc_addlistitem in Sharepoint to accomplish this and the procedure actually works great and puts the list item in the AllUserData table perfectly!
The problem is that Sharepoint doesn't update the actual listitems on the client side. For example, I insert a new item and validate the data, then I go to our local sharepoint site and the listitem DOES NOT appear in the list! What! I can't figure this out.
I can't move on to the next step in my data flow without figuring out why Sharepoint is not showing my data after inserting values.
View Complete Post