Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Migrating SharePoint List Data between SharePoint instances using SSIS

Posted on 2014-10-29
1
Medium Priority
?
215 Views
Last Modified: 2016-02-11
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!
0
Comment
Question by:polaris101
1 Comment
 
LVL 15

Accepted Solution

by:
colly92002 earned 2000 total points
ID: 40412294
Is this SharePoint 2010?   If so, the SSIS module on Codeplex is really more useful to extract data from SP into SQL.

If this is a one-of copy, I would recommend you simply save the list as a template and tick the box to include the data, then create a new list using the created file as a template on your destination.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question