Uslu

Hello,

I have a package that reads data from a SharePoint list through an Access database using linked tables. Package is using an OLE DB connection to connect to access and everything works fine except that package keeps asking for username and password to connect to the sharepoint list. I played with the security settings in the OLE DB connection but that didn't help. Is there any way to configure the connection so that it uses windows authentication

If I a open the access database directly in access, it doesn't require any username or password to view the data from sharepoint list.

Thank you

Akin



Re: SharePoint - General Question and Answers and Discussion how to setup trusted connection to a sharepoint list through Access DB

Phil Brammer

Moved from SSIS to Sharepoint - general q & a





Re: SharePoint - General Question and Answers and Discussion how to setup trusted connection to a sharepoint list through Access DB

Uslu

Himm, not sure if sharepoint folks would know what a package is or anything like. My quess is that this issue has something to do with a parameter setting in OLE DB connection in SSIS. Don't you think