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
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.