Langsung ke konten utama

Configure an SSIS Package to Execute as a Proxy Account


If an SSIS package needs to execute with specific permissions, you can create a service account for it to use, and the developers can configure the packages to inherit the run as account so that they never need to know what the password is.
Proxies can be used with just about any kind of SQL job step, not just SSIS packages.

8 Steps total

Step 1: Create a New Credential


Expand
Create a credential under the server-level Security tab by right-clicking on the Credentials node and clicking New Credential...

Step 2: Enter Credential Information


Expand
Enter a name for the Credential, the Windows account you want it to use as Identity, and enter the password for the account twice. Optionally, you can specify which encryption provider to use. Then click OK.

Step 3: Create a New Proxy


Expand
Expand the SQL Server Agent node, right-click on Proxies, and click on New Proxy...

Step 4: Enter Proxy Information and Assign Proxy


Expand
Give the proxy a name, assign it the Credential you created, optionally give it a description, and assign it to the SQL Server Integration Service Package subsystem. You can assign it to other subsystems at this time or any time later if desired.

Step 5: Grant Access to other Principals (Optional)

By default, only sysadmins can assign proxies to job steps. If you want to allow others to assign a proxy, switch to the Principals tab and add their login. Most of the time, you will not do this step in production, but may opt to do so in nonproduction environments.

Step 6: Click OK when Proxy info entered.


Expand
After pressing enter, the Proxy will show under all specified subsystems. Proxies that have not been assigned, if any, will show under the last tab, Unassigned Proxies.

Step 7: Assign the Proxy to a Job Step


Expand
When creating or modifying a job step for an SSIS package, you can set the Run as account to be a proxy account (default is SQL Server Agent Service Account). The job will only allow you to choose from proxies that were already assigned to the subsystem at the time the job step dialog was opened. If you create a new Proxy while the dialog is open, close it and reopen it to see any new proxies.

Step 8: Save job step when complete

Label:

Komentar

Posting Komentar

Silakan dikomen...

Postingan populer dari blog ini

CREATE CROSS TAB QUERY IN MYSQL

MySQL Multi-Aggregated Rows in Crosstab Queries MySQL’s crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis. Today’s topic of discussion is crosstabs, which contain multiple aggregate functions in the row axis of a tabular resultset. Recall from the the  All About the Crosstab Query  article that an aggregate function is one that summarizes a group of related data in some way. Examples of aggregate functions include COUNT, SUM, AVG, MIN, and MAX. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to two or more fields. Today we’ll create a query...
Posting Komentar
Baca selengkapnya

Mysql Import data from CSV File

  Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\PSI011>cd C:\xampp\mysql\bin C:\xampp\mysql\bin> mysqld 2017-08-22 14:24:49 15428 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 16352 ... C:\xampp\mysql\bin> mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.1.25-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use pkh; Database changed MariaDB [pkh]> LOAD DATA LOCAL INFILE 'D:/2017/PKH_FOR_BPKP/PKH_FOR_BPKP_01.csv' -> INTO TABLE pkh_bpkp -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '"' -> ESCAPED BY '"' -> LINES TERMINATED BY '\n...
Posting Komentar
Baca selengkapnya

Pentaho Data Integration: Membuat Koneksi ke database MSSQL Server 2008 R2

Untuk terhubung ke database SQL Server langkah-langkah berikut harus dilakukan:   Download Driver Microsoft JDBC di https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774  Tutup Spoon atau Kettle project  Unzip/extract paket dalam direktori temporer (bebas) Copy '<temp directory> \ sqljdbc_6.0\enu\auth\x64\ sqljdbc_auth.dll' ke 'C:\Program Files\Java\jre1.8.0_131' atau sesuaikan dengan path java runtime terinstall  Copy '<temp directory>\ sqljdbc_6.0\enu\jre8\sqljdbc42.jar' ke '<Kettle folder instalasi> \ data-integration \ lib' Buka Spoon atau Kettle project Uji koneksi dalam Spoon Hapus direktori temporer karena sudah tidak digunakan lagi Jika kita meng-upgrade Kettle, Java, JDBC Driver ke versi yang lebih tinggi, maka serangkaian langkah-langkah di atas harus diulang lagi.
2 komentar
Baca selengkapnya