R
rkutz
I'm having a problem getting data out of Sharepoint into a SQL Server
database using SSIS. Let me explain what I've done and the problem that I'm
encountering.
There is a sharepoint list on the server with data that I need to extract on
a nightly basis and update tables in SQL Server 2005. To do so, I've created
an access database with linked tables and am querying the linked tables in
the access database which passes the request on to sharepoint and returns the
data. So far so good, it's a bit slow but it works, at least in the BI
design studio. The problem comes when I'm trying to run the package on a
server. I have some limitations on my server access and am running the
package using dtexec under an alternate user name using a 3rd party job
scheduler. When the pakage runs, it just hangs and never completes. From
what I can tell by creating logs on the server, the last status in the log is:
ExternalRequest_pre: The object is ready to make the following external
request: 'ICommandPrepare:
repare'
I had a user who does have direct access to the server run the package
manually, and it prompted him to authenticate to the sharepoint site even
though I've granted permissions to his account and the account that runs the
package through the job scheduler, so I believe the problem through the job
scheduler is that the package hanging because it needs to authenticate to the
sharepoint site.
So, does this sound like it may be the problem, and if so, how do I get
around it so that the package will automatically authenticate to the
sharepoint site without needing to prompt a user to enter credentials?
database using SSIS. Let me explain what I've done and the problem that I'm
encountering.
There is a sharepoint list on the server with data that I need to extract on
a nightly basis and update tables in SQL Server 2005. To do so, I've created
an access database with linked tables and am querying the linked tables in
the access database which passes the request on to sharepoint and returns the
data. So far so good, it's a bit slow but it works, at least in the BI
design studio. The problem comes when I'm trying to run the package on a
server. I have some limitations on my server access and am running the
package using dtexec under an alternate user name using a 3rd party job
scheduler. When the pakage runs, it just hangs and never completes. From
what I can tell by creating logs on the server, the last status in the log is:
ExternalRequest_pre: The object is ready to make the following external
request: 'ICommandPrepare:
repare'I had a user who does have direct access to the server run the package
manually, and it prompted him to authenticate to the sharepoint site even
though I've granted permissions to his account and the account that runs the
package through the job scheduler, so I believe the problem through the job
scheduler is that the package hanging because it needs to authenticate to the
sharepoint site.
So, does this sound like it may be the problem, and if so, how do I get
around it so that the package will automatically authenticate to the
sharepoint site without needing to prompt a user to enter credentials?