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!!
Best Answer
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.