Sometimes even the easy things can be hard… It doesn’t matter how many times I attempt to explain how to use the SSIS Adapters available on Codeplex with source code and documented on MSDN I seem to fail. So this time I will include pictures… However, this post assumes you have read the SharePoint List Adapter Readme and the MSDN article..
This example uses two Calendars; Calendar is the source and Calendar.MSDN is the destination
After Installation and Configuration of VS2008 you should be able to complete the following:
2. Fill in the Properties of the SharePoint List Source and drag the green connector to the Destination
Example List Source SiteURL http://trex-si-11, ListName Calendar, ViewName Calendar
Example List Destination SiteURL http://trex-si-11, ListName Calendar.MSDN, ViewName Calendar
3. Next Map the Columns on the List Destination but do NOT Include ID if you want the Source to Create a Row on the Destination, Include an ID if you want the Source to Update the Destination..
The rules are:
Execute the Task and if its green your good to go. However, the rules above mean that you will probably need more than one Data Flow to handle the different scenarios
The MSDN Article By Kevin Idzi and the Readme should pretty much explain all you need to know so I have to wonder why I am explaining it again, for everyone who did not know the references…