Thanks for your post.I m in a process of running a SSIS package from SQL Job. The package extracts data from a SharePoint list to sql table using http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652When I run it as myself( I have access to SharePoint server site), it runs fine. But when I try to run as a system user, it fails.
SO i m thinking of a way to add the server pwd-A that hosts SQL Server to the SharePoint farm so that SharePoint when sees that ok here's SQL Job from Pwd-A AS a System user is trying to access my list items, so lets grant it access! kind of...
Please let me know if that explanation gave some ideas.