With the OData Data Source for SQL Server 2012 connectors installed, I am unable to retrieve SharePoint 2013 list columns that are defined as multi-choice.  I am able to retrieve other columns, but not the multi-choice ones.  Is this a known problem/limitation with the OData data source?  Is there a work-around?

Hi Phil-Armstrong,

After testing the issue in my environment, I can reproduce it. As per my understanding, it seems like a known issue. So, it is my pleasure to help you to reflect your recommendation to the proper department for their consideration. Please feel free to submit your situation on our product to the following link https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided.

To work around this issue, we can use SSIS SharePoint List Adapters for SharePoint 2013.

The following steps test in my environment are for your references:

1. Download and Install SharePointListAdaptersSetup.msi or SharePointListAdaptersSetup_x86.msi.
2. Right-click the SSIS Toolbox pane to Refresh Toolbox, then we can see SharePoint List Source and SharePoint List Destination under Common group.
3. Create a SharePoint connection as SharePoint Credential in the package.
4. Double-click SharePoint List Source or SharePoint List Destination to open the dialog box.
5. Select the SharePoint Credential as Connection Manager in the Connection Managers pane.
6. In the Component Properties pane, paste the URL for the SharePoint site into the SiteUrl (exclude anything from the word Lists onward in the URL)
   Example: if your SharePoint site URL for Lists is
   http://sp2k13/sites/report/Lists/11/AllItems.aspx
   then type http://sp2k13/sites/report as SiteUrl, type 11 as SiteListName, type All Items as SiteListViewName.
7. Finishing the mapping in the Column Mappings pane.

The following screenshot is for your reference:

Reference:
How To Use a SharePoint List as a Data Source in your SSIS Package

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong