Skip to main content

Preparing to run the SQL Server Integration Services collector

Important

This collector is available in Private Preview. If you would like access to this collector, please contact your Customer Success Director.

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.

Item

Requirement

Hardware (for on-premise runs only)

Note: The following specs are based upon running one collector process at a time. Please adjust the hardware if you are running multiple collectors at the same time.

RAM

8 GB

CPU

2 Ghz processor

Software (for on-premise runs only)

Docker

Click here to get Docker.

data.world specific objects (for both cloud and on-premise runs)

Dataset

You must have a ddw-catalogs dataset set up to hold your catalog files when you are done running the collector.

If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors.



Preparing SQL Server Integration Services (SSIS)

Creating a user and assigning permissions

  1. Follow the Microsoft documentation to create a user login with SQL Server Authentication.

    Note

    The collector does not support Windows New Technology LAN Manager (NTLM) authentication. It only supports SQL Server Authentication using username and password.

  2. To assign a user with SQL Server Authentication the necessary permissions for the Package Deployment Model, grant one of the following:

    • Membership in the db_ssisoperator role

    • All of the following privileges:

      • SELECT on msdb.dbo.sysssispackages

      • SELECT on msdb.dbo.sysssispackagefolders

  3. For the Project Deployment Model, grant the user one of the following permissions:

    • Membership in the ssis_admin database role.

    • Membership in the sysadmin server role.

    • All the following privileges:

      • SELECT on the following tables and views:

        • SSISDB.catalog.projects

        • SSISDB.catalog.folders

        • SSISDB.catalog.packages

        • SSISDB.catalog.environments

        • SSISDB.catalog.environment_variables

        • SSISDB.catalog.environment_references

        • SSISDB.catalog.object_parameters

        • SSISDB.catalog.object_executions

        • SSISDB.catalog.object_operations

      • EXECUTE on SSISDB.internal.get_project_internal

      • READ on every extracted project

In this section: