I need to export excel file/sheet data from Sharepoint(file is on Sharepoint site) and import to SQL using SSIS. Is this is even possible. What are the steps.
I know i can download these excel files from SharePoint site to a folder and then import to SQL, that's easy! but i need to know how to do it directly from Sharepoint site.
Thanks!!
If you file is stored in SharePoint library, you can access it as if it were on a network location.
If the button is grayed out that means you are lacking access privileges. Talk to your SharePoint administrator.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With