我们应该在解决方案中的多个项目之间分隔sis软件包吗？ [英] Should we separate the ssis packages between several projects in our Solution?

问题描述

我使用 SSIS2012 。我在数据仓库中创建了三个架构（ STG ， TRSF ， DW ）。

I use SSIS2012. I have created three schema in my Data warehouse(STG, TRSF, DW).

STG架构用于登台表。我所有的源文件都是CSV文件。我正在将数据从源传输到stg模式中的每个表。我为每个表都有一个单独的包（例如：如果我有20个csv文件，我将有20个包，我将在stg模式中填充20个表）

The STG schema is for staging tables. All my source file are the CSV files. I am transferring the data from my source to each table in stg schema. I have a separate package for each tables (For example: If i have 20 csv files, I will have 20 packages and i will populate 20 tables in stg schema)

之后那就是我正在将 stg 模式转移到 trsf 模式。在那些过程中，我有生意。我确实在查找FK，并且其他业务规则将在此级别中应用。与私有示例相同，如果我在 stg 模式中有20个表，那么我将有20个包，在 trsf 模式。

After that, I am transferring stg schema to trsf schema. During those process i have my business. I do lookup for FK and other business rules will be applied in this level. The same as privious example if I have 20 tables in stg schema, I will have 20 packages and I will fill 20 tables in trsf schema.

第三步，我将数据从 trsf 模式传输到 dw 模式。这里我还有20个程序包。

In third step I will transfer the data from trsf schema to dw schema. Here also I have 20 packages.

最后，我将有20个程序包用于清理 stg 模式中的表

At end, I will have 20 package for cleaning the tables in stg schema.

我为csv文件和 dw 模式中的表之间的每个转换创建4个程序包。

I create 4 packages for each transformation between csv files and the tables in dw schema.

我想知道为每个步骤创建4个单独的项目是否是个好主意？因为现在，我在一个项目中有80个软件包，并且可以再增加一些。

I would like to know if it is good idea to create 4 separate projects for each step? Because now, I have 80 packages in one project and it can be grow up more.

推荐答案

我将这些项目放在一起。但是要分开它们，我将为着陆，登台和数据仓库保留单独的父级工作。您可以通过主控父作业来控制这些父作业。这将使您可以自由地独立运行各个阶段。

I would keep the projects together. However to separate them, I would keep separate parent jobs for Landing, Staging and the Data Warehouse. And you could control these Parent jobs by a Master Parent jobs..This would give you freedom to run individual stages independently.

另一个建议，我建议您将着陆装置分开，暂存和数据仓库位于单独的数据库中。相信我从长远来看会对您有帮助。

Another suggestion, I would suggest you separate the Landing, Staging and the Data Warehouse in separate databases. Believe me it would help you in the long run.

欢呼
Nithin

Cheers Nithin

这篇关于我们应该在解决方案中的多个项目之间分隔sis软件包吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！