Thursday, July 26, 2012 8:35 PM
I have a new Integration Services Project and I'm using the DQS cleansing control. My SSIS package executes well since I have configured the the DQS control to use my user credential to connect to the DQS specific databases (e.g. DQS_Main, DQS_Projects and DQS_Staging_Data). However, when I go to production I would like to create one account that can be use for the various DQS constrols used through out my Integration Service Project.
What is the best way to create a connection string to connect to a DQS database and to provide credentials. I would like to create one connection/provider using a specific account when connecting to a DQS database.
FYI....I have tried creating a new DQS connection via connection manager but I never have a chance to pipe in different credentials.
Thanks for any help.
Friday, July 27, 2012 2:28 PMModerator
Its only permits Windows Authentication. This means that the account which launches the SSIS Package (your interactive account, SQL Agent service account, proxy account) is the one that logs in to run DQS work.
You cannot specify SQL authentication for DQS. Therefore, you have no options except to set the proxy account for the job which runs the SSIS package.
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
- Proposed As Answer by Jason H - SQLMicrosoft Employee, Moderator Friday, July 27, 2012 10:56 PM