November 17, 2014 at 12:59 am
Just wondering if it's possible to read an MS Access database in OneDrive from an SSIS package?
November 17, 2014 at 1:58 am
If the account you are running the SSIS package with is the same as the SkyDrive/OneDrive) account and you are running it on a machine that is connected to OneDrive, you should be able to.
You might have to use the local OneDrive directory/path (C:\Users\UserProfileName\SkyDrive) to access it.
I haven't tried it myself, but was able to run this code from the SQL Server command shell on my local PC, and access folders on my OneDrive:
exec xp_cmdshell 'dir C:\Users\UserProfileName\SkyDrive /s/b'
I have thought about using it to backup the local SQL Server databases on my PC directly to OneDrive, but I haven't had a change to try it yet.
Please post again to let us know if you get it to work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply