I've started a new SSIS project which needs to sync daily a SharePoint list into a SQL 2008 database.
Every day the SP list is updated with new suppliers. It is associated to a validation workflow in order to get a clean list.
My SSIS project is looking good so far, when I run it I'm able to get approved records from the SP list into my SQL table.
But I need to go further. I need to tell to the SP list that the datatset I have at the end of my SSIS flow has been synced.
I need to do that in order to have these records only once otherwise at the next run I'll get duplicates.
So my idea was to go for a boolean field in the SP list and update this field and the end of my data flow.
I'm deriving the colum in order to update that in my flow. I set all the records to IsSync == True
But when I run the flow and I check the SP List...only the version field in the SP list has changed and nothing else!
Any help would be appreciated !
View Complete Post