cara membuat SSIS Catalog atau biasa disebut SSISDB

Setelah lu membuat desain dan test package di SSDT atau SQL Serer Data Tools, lu bisa deploy project yang sudah lu buat agar bisa dijalankan secara otomatis. Jadi package yang lu buat tidak perlu lu jalanin manual.

Namun sebelum itu, khusus SQL Server 2012 ke atas, lu harus buat dulu SSISDB catalognya. Agar bisa menjalankan job yang akan lu buat.

Langsung aja kita belajar untuk membuat nya !

Ada 2 cara , yang pertama melalui SQL Server Management Studio dan yang ke 2 melalui PowerShell.

Cara 1 : Membuat SSISDB melalui SQL Server Management Studio

1. Buka SQL Management Studio dan Connect to the SQL Server Database Engine.

2. In Object Explorer, expand the server node, right-click the Integration Services Catalogs node, and then click Create Catalog.

3. Click Enable CLR Integration.

4. The catalog uses CLR stored procedures.

5. Click Enable automatic execution of Integration Services stored procedure at SQL Server startup to enable the catalog.startup stored procedure to run each time the SSIS server instance is restarted.

6. The stored procedure performs maintenance of the state of operations for the SSISDB catalog. It fixes the status of any packages there were running if and when the SSIS server instance goes down.

7. Enter a password, and then click Ok.



Cara 2 : Membuat SSISDB catalog melalui PowerShell

Execute script ini di PowerShell :

# Load the IntegrationServices Assembly  
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices")  

# Store the IntegrationServices Assembly namespace to avoid typing it every time  
$ISNamespace = "Microsoft.SqlServer.Management.IntegrationServices"  

Write-Host "Connecting to server ..."  

# Create a connection to the server  
$sqlConnectionString = "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;"  
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString  

# Create the Integration Services object  
$integrationServices = New-Object $ISNamespace".IntegrationServices" $sqlConnection  

# Provision a new SSIS Catalog  
$catalog = New-Object $ISNamespace".Catalog" ($integrationServices, "SSISDB", "P@assword1")  
$catalog.Create()

Ngerti kaga bang, ba ? 

pasti ngertilah ya,,,

Klo kaga ngerti lu buka website gua yang satunya lagi nih link nya https://translate.google.com/

lu copy pembahasan nya, klo sciptnya jangan lu terjemahin malah error nnti klo di Execute di SQL

Terimakasih sudah membaca, semoga bermanfaat.
Dan jangan lupa tinggalin jejak biar gua tahu klo tulisan gua ada yang baca.
Terimakasih