Differences

This shows you the differences between two versions of the page.

--- ssis_proxy_verbose_logging_cheat_sheet [2025/06/30 14:43] – oso
+++ ssis_proxy_verbose_logging_cheat_sheet [2025/06/30 14:47] (current) – oso
@@ Line 3: / Line 3: @@
 === 🛠️ Running SSIS Job Steps as a Proxy ===
-To run an SSIS package as a different user (e.g. `tasca\administrator`), follow these steps:
+To run an SSIS package as a different user (e.g. ''domain\administrator''), follow these steps:
 == 1. Create Credential ==
@@ Line 9: / Line 9: @@
 USE [master];
 CREATE CREDENTIAL [ssis_cred_admin]
-WITH IDENTITY = N'tasca\administrator',
+WITH IDENTITY = N'domain\administrator',
      SECRET = N'YourDomainPasswordHere';
 </code>
@@ Line 38: / Line 38: @@
   * Type: **SQL Server Integration Services Package**
   * Run as: **SSIS Proxy Admin**
+<WRAP center round important 60%>
+You’re not creating a new user — you're just wrapping sa in a credential and proxy. A credential is a way to associate a username and password with a proxy in SQL Server Agent. You’re essentially telling SQL Server, “Here’s how to impersonate 'domain\administrator' when needed.”
+</WRAP>
 ---