如何使用ssis将文件上传到一个驱动器? [英] How to upload files to one drive using ssis?

问题描述

我正在寻找一种使用SSIS将文件上传到One Drive的方法.我已经研究过，并且有一些第三方工具(例如CozyRoc，KingswaySoft)提供了一个驱动器连接管理器.那里有人有经验吗?如果是这样，请分享！

I am looking for a way to upload files to One Drive using SSIS. I've researched and there are some third party tools like CozyRoc, KingswaySoft which provide one drive connection manager. Anyone out there who already have experience doing this? If so please share!

推荐答案

我发现了一种不需要任何第三方软件的简便方法.将一个驱动器下载到本地计算机，然后登录. 您可以上传，下载，删除文件.要在Windows上映射One Drive for Business云驱动器，请执行以下步骤

I found a much easier way to do this without the need of any third party software. Download one drive to your local machine and then login. You can upload, download, delete files.To map the One Drive for Business cloud drive on Windows follow the below steps

在文件资源管理器(我的电脑)中映射网络位置

Map network location in File Explorer (My Computer)

       a. Open File Explorer (or My Computer in older Windows) and select This PC on the left side tree.

       b. Click on Add Network Location button in the ribbon (or right click on empty space in File Explorer and select Add Network Location).

在此处在文件资源管理器中映射网络位置

       c. Click Next on Add Network Wizard window

       d. Click to select Choose custom network location and click Next

       e. Copy the URL from the address box and add Documents in the end like below example  

          https://<your Office365 tenant name>-my.sharepoint.com/personal/<yourrname>_company_com/Documents 

添加网络向导"窗口

       f. Enter a name for your network location and click Next and Finish to complete the wizard.

网络位置名称

      g. You will find the mapped network location in My PC section.

映射的网络位置

使用文件系统任务"上载，创建，删除等.操作完成.

Use File System Task to upload, create, delete etc.. And you're done.

这篇关于如何使用ssis将文件上传到一个驱动器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！