I’m wondering if it’s possible to read a flat file that is stored on a Sharepoint server directly using the UNC path.
Right now i’m getting an error that “either the path or permissions” are not correct.
But i’m also wondering if it’s even possible to access it directly by using a format configured with the UNC path. I’m doubting if we can do this as the files are stored inside a database and not really on a disk somewhere.
the UNC equivalent is usually
\sharepoint\mydoc\library
and you can use that in your BODI job. The caveat is that Windows authentication is required, so whatever user your BODI services are running under (on the job server) needs permissions to that sharepoint library. And they should be in the same domain etc.
For the information. Right now i’m still getting the following error when i try to access the file from the BO server.
“Cannot open file <\Path\file.txt>. Please check its path and permissions.”
When i log on from a different location, as i cant log in on the BO server, i can access the files using the user specified on the job service.
I’m guessing it’s a network issue then. I’ve done a firewall change request asking to open port 445 to allow windows sharing between both servers. Is there anything else i need to think about?
i mapped a sharepoint path to a mapped drive on my BODS server. Now when i login to my BODS dataflow , and point to this file and mapped drive , i can preview data . But when i run the job , i get “Check Path and Permissions” error.
I am able to access the path from run prompt also on the server.
I’d take a guess that your user account for Designer does have access to the mapped drive, but the service account that the job server uses to run jobs does not.
(BOB member since 2006-11-02)
(BOB member since 2004-01-30)
(BOB member since 2006-11-02)
(BOB member since 2004-12-17)
(BOB member since 2004-12-17)
(BOB member since 2004-06-09)