Export Sharepoint Excel Sheet to SQL using SSIS

Question

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

What data is stored in this Excel sheet? Is it the result of a report being run or users inputting information which is then archived in the SQL tables? — TJH, Commented Aug 15, 2013 at 10:26
Take a look at this: stackoverflow.com/questions/12385431/… — brl8, Commented Aug 28, 2013 at 22:31

user11060917 · Accepted Answer · 2019-07-10 04:36:05Z

1

If you file is stored in SharePoint library, you can access it as if it were on a network location.

Open SharePoint Library with your Excel file in IE browser.
Go to Library Tools -> Library tab.
In Connect & Export section there should be Open with Explorer button.
Click on it and you should get a Windows Explorer window. Copy the path from this window's header to SSIS Excel connection manager and you should be able to access your file directly from SSIS.

If the button is grayed out that means you are lacking access privileges. Talk to your SharePoint administrator.

edited Jul 10, 2019 at 4:36

user11060917

372 silver badges8 bronze badges

answered Feb 4, 2014 at 18:55

Esc

1951 gold badge2 silver badges9 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Export Sharepoint Excel Sheet to SQL using SSIS

1 Answer 1

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related