Page Comparison

...

1. Deploying and orchestrating the extract code

2. Managing a high water mark so the extract only pull the latest metadata

3. Storing and pushing the extracts to your K instance.

...

Pre-requisites

...

Collector Server Minimum Requirements

SSIS Requirements

MSDB database / SQLServer DB access

• if using SSISDB to store package you will need to download each project via SQL Server Management Studio. See https://kadaai.atlassian.net/wiki/spaces/KSL/pages/1960706049/SSIS+Collector+method+-+v3.1.0#Downloading-SSISDB-packages

  • The collector will need access to the underlying SQLServer Database with permissions to read the following tables is the SSIS main databases:

    • MSDB.DBO.SYSSSISPACKAGES

    • <SSIS Logging Database>.DBO.SYSSSISLOG where <SSIS Logging Database> is the database configured for SSIS logging

  Access to K landing directory

• Check your SSIS instance port

  • Run the following query and note the local tcp port.

    Code Block
    SELECT local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID GO

Downloading SSISDB packages

1. In SQL Server Studio Manager Go to Integration Services Catalog > Projects.

   

2. Right click on a Project > Export…
   

   

3. Save project file

   

4. Change the file extraction from .ispac to .zip

   

5. Repeat for each project.

...