我在OneDrive（团队）上有一个Excel文件。我想将来自Excel文件的数据导入SQL表。我可以使用哪些SSIS任务？
这是我尝试过的（）
- ： //www.techbrothersit.com/2016/07/how-to-download-file-file-from-sharepoint-by.html
- 在Visual Studio中复制链接
，创建新的SSIS项目，创建新连接（HTTP） - 这将创建 http Connection Manager
-
，将服务器URL当作从步骤1
- 单击测试连接 - 错误：远程服务器返回错误：
（403）禁止时，将提供服务器URL。即使我输入凭据，也会得到相同的错误。
如果我将链接粘贴在Web浏览器（隐身模式）中，则它将在浏览器中打开Excel文件。
我还尝试了 odata连接管理器，同样的错误。
其他引用（相同错误）：
https：// edimpor.com/@smitagudale712/download-excel-file-file-from-online-inline-insis-a830c32389f5
https://sqlis.com/downloading-a-file-ove-http-the-ssis-way/
I have an excel file on OneDrive (teams). I want to import the data from the excel file into SQL table. Which SSIS task can I use for this?
Here is what I have tried (https://www.techbrothersit.com/2016/07/how-to-download-file-from-sharepoint-by.html)
-
In Onedrive (teams), Share the file with everyone, copy link
-
In visual studio, create a new SSIS projects, Create new connection (HTTP) - this creates the HTTP connection manager
-
In the new http connection give the server url as the link copied from step 1
-
Click on test connection - error: The remote server returned an error: (403) Forbidden. Even if I enter my credentials then also I get the same error.
If I paste the link in web browser (incognito mode), then it opens the excel file in browser.
I also tried the OData connection manager, same error.
Other references (same error):
https://medium.com/@smitagudale712/download-excel-file-from-online-in-ssis-a830c32389f5
https://sqlis.com/Downloading-a-file-over-HTTP-the-SSIS-way/
发布评论