CODEWITHSUNDEEP
ssis
John W.
John W.

Reputation: 1764

SSIS Connection Manager using service account

How do I specify my SSIS package to use a domain service account when deployed and called from an Agent Job?

The Connection Manager is set to use [Windows Authentication], so I think it is using my windows credentials during development. However I want the package to use a domain service account with a non-expiring password when running as a Job on SQL Server.

How can I do this? Thanks for any guidance.

Upvotes: 2

Views: 4594

Answers (1)

Ferdipux
Ferdipux

Reputation: 5256

You or your DBA should do the following on the SQL Server:

  • Create a SQL Credential for a desired Domain Account.
  • Create a SQL Agent Proxy of type SSIS Package Execution and bind it to the Credential created.
  • On the SQL Job step - specify created Proxy in Run As: dropdown

These steps allows to run specified SSIS Package under account of the SQL Credential.
Here is a good sample on how to set it up.

Upvotes: 2

Related Questions