Hello, how can you extract an Excel workbook stored in my company's Sharepoint? Using the Excel source, only local or network-share files can be imported. Google searches are showing that some people use HTTP connection + Script task to download the Excel from Sharepoint to local computer and then do their transforms, etc. on the local file before loading into destination. My requirement is I cannot download the file to local.
Without downloading the file to local it won't work. I work on one of the project where I had to import the file from sharepoint to sql server and for that first I had to download the excel file to server folder and then I imported it from there.
![Bulk Copy Program (BCP) Utility to Import and Export Data in SQL Server [HD]](/img/n.gif)
Awesome Nice Explanation
Thank you.
you provide online classes?? please confirm
No Reena, I don't provide the online classes.
Can you email me at aqil33@gmail.com ?
Hello, how can you extract an Excel workbook stored in my company's Sharepoint? Using the Excel source, only local or network-share files can be imported. Google searches are showing that some people use HTTP connection + Script task to download the Excel from Sharepoint to local computer and then do their transforms, etc. on the local file before loading into destination. My requirement is I cannot download the file to local.
Without downloading the file to local it won't work. I work on one of the project where I had to import the file from sharepoint to sql server and for that first I had to download the excel file to server folder and then I imported it from there.