SP List Destination Adapter for 2005 with connection manager.

Jul 16, 2010 at 4:00 PM
I see there's a beta out which includes a connection manager, I'm wondering if there is one out for SQL2005. I'm in a real fix, as the machine that's running the agent stays logged in as the administrator. This causes an issue when the agent creates list items in Sharepoint, as it does so as the SYSTEM ACCOUNT, and workflows I have attached to the list do not start as a result. I would be very grateful if someone could help me setup the adapter to use a different credential when writing to Sharepoint.
Jul 19, 2010 at 4:48 PM

The machine that is running can stil be administrator. You can setup a SQL Credential and SQL Proxy to execute the job step for SSIS in a different credential. That is the easiest way to handle the credentials.  I did put a beta of 2005 up there, but generally running the sql job step with the proxy that has the credentials is a good way to go about this.