ssis 创建ssisdb_SSIS目录数据库（SSISDB）简介

ssis 创建ssisdb

In this article, I am going to explain in detail the SSIS catalog that can be used to deploy SQL Server Integration Services (SSIS) projects. Using this catalog, developers and database administrators can easily deploy and manage their integration services projects after deployment. The SSIS Catalog database was introduced in SQL Server 2012 and prior to that users had the following three options to deploy their SSIS packages:

在本文中，我将详细解释可用于部署SQL Server Integration Services（SSIS）项目的SSIS目录。 使用此目录，开发人员和数据库管理员可以在部署后轻松部署和管理其集成服务项目。 SSIS目录数据库是在SQL Server 2012中引入的，在此之前，用户具有以下三个选项来部署其SSIS包：

• Users could deploy the packages to a directory on the file system
  用户可以将软件包部署到文件系统上的目录中
• Users could deploy the packages to the package store which ultimately stores the packages on the file system but inside the SQL Server directory instead
  用户可以将软件包部署到软件包存储中，该存储最终将软件包存储在文件系统上，但存储在SQL Server目录中
• sysssispackages” table sysssispackages ”表中

创建SSIS目录 (Creating the SSIS Catalog)

In order to create the SSIS catalog database, you need to have SQL Server already up and running on the machine, to begin with. This catalog database is just another simple database object which helps us store the SSIS packages in a more organized way.

为了创建SSIS目录数据库，首先需要在计算机上启动并运行SQL Server。 该目录数据库只是另一个简单的数据库对象，可帮助我们以更有条理的方式存储SSIS包。

To create this catalog database, right-click on the “Integration Services Catalog” option and select “Create Catalog…”. In the Create Catalog dialog box that opens up, enable the checkbox for “Enable CLR Integration” and provide a password for the catalog database. You will usually not require this password to use the SSIS objects within the catalog database.

要创建此目录数据库，请右键单击“ Integration Services目录 ”选项，然后选择“ 创建目录... ”。 在打开的“创建目录”对话框中，启用“ 启用CLR集成 ”复选框，并提供目录数据库的密码。 通常，您不需要此密码即可使用目录数据库中的SSIS对象。

Figure 1 – Create the Catalog Database using SQL Server Management Studio

图1 –使用SQL Server Management Studio创建目录数据库

I have already enabled the catalog database in my machine, so I will not be able to share the screenprints at the moment. However, once you are done with setting the password, hit OK and that will be it. The new catalog database will be created, and you can see