Solved

Migrating SharePoint List Data between SharePoint instances using SSIS

Posted on 2014-10-29
1
181 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 15

Accepted Solution

by:
colly92002 earned 500 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

732 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