I'm new to SSIS, need to retrieve SharePoint List Items and send to SQL Server Database. I know how to do it using OData Source, but the list has a multi-select lookup column and this column is not showing in the results in SSIS as it is not in the m:properties.

Is there a way to get the list items in SSIS using _api/web/lists? Maybe using Script Task? Python?

Note: Cannot use 3rd party solutions, cannot purchase anything in my company.

Please provide a step-by-step answer as I have no idea where to start. I tried following some answers I found on this forum, but it seems I'm missing something.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.