Hi All, I have a business requirement to migrate SharePoint List data from one SharePoint instance to another SharePoint instance. (Lists are not in the same Site Collection/Web App, but completely separate instance). I've been experimenting with SSIS and the Source and Destination adapters on Code Plex
and I think I'm very close. However, there are a few important columns that are not coming over properly and that is the SharePoint "Choice" column type with "Checkboxes (allow multiple selections)".
As you could imagine the data in those columns cover over, but not properly even when the destination column is also a lookup with the same options. It looks something like this when multiple selections are in a single column: 2, OptionA, 1, OptionB
I have basic experience with SP Designer and SSIS and am more on the Admin side, not development. I realize this wouldn't be fully supported by Microsoft, but we do need to migrate this data somehow.
Any help is much appreciated. Thanks!