Connection String

Jun 19, 2014 at 12:44 AM
I am trying to pass a connection string to the SCHERD connection manager via a variable but do not know what the connection string should contain. Does anyone have an example of a connection string that I could store the User name and Password in a variable then pass to the SharePoint Connection? I try to add the password and User Name in SCHERD but it erase it when I save the file and reverts to current user. Which works for me but not so good for the Server Agent that I want to send the package to.
Any help would be greatly appreciated.