How to upload files to one drive using ssis?

2019-07-29 22:18发布

问题:

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!

回答1:

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).

Map network location in File Explorer here

       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 

Add Network Wizard window

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

network location name

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

Mapped Network location

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



回答2:

Our SSIS Productivity Pack offers OneDrive Destination component which supports Create/Update/Delete data from your OneDrive. You can download the toolkit and give it a try, if you run into any problems, please feel free to let us know. We are more than happy to help!