What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

10 pts.
Tags:
BI
Business Intelligence
Data Connector
Excel 2003
Excel Services
Microsoft Excel
Performance Point
SharePoint
SharePoint permissions
SSIS
SSIS Sharepoint
I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script that will run every monday morning to update the datamart with any new metric data (combined key = MetricID and ReportWeek); ie. every metric has one value for each week...so the script will either add a record or update an existing record as appropriate. My problem is that I can read an excel file from my desktop, but when I use the path to the excel file on the sharepoint I get an error message: "Microsoft JET Database Engine - ! Failure creating file." this is in the Excel Source Editor tool in the Business Intelligence Development Studio. My SharePoint Admins have added my directory into the 'Shared Services Administration, Excel Services Trusted Data Connection Libraries'...but I seem to still have a connection problem to that sharepoint library. any ideas?
ASKED: February 3, 2009  4:57 PM
UPDATED: February 3, 2009  5:07 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following