I am at a lost on how best to synchronize data between a SharePoint List and a SQL Table. I have installed the adapter found here: http://sqlsrvintegrationsrv.codeplex.com/. I've got it to pull the data from the SharePoint List to my table. What I need now, and don't know how to do, is when changes are made to the list or new information is add, how do I reflect those changes in the SQL table? I don't need to write back to the list only pull from it.
I know about SharePoint BCS, but we don't have access to it with our implementation of SharePoint (not sure why). So, SSIS is my only option.
I am not an SSIS expert, so any step by step directions someone can point me to/provide would be most appreciated. Thanks.
Using SQL Server 2008 and SharePoint 2010