我应该为 SSIS 项目签入哪些文件? [英] What files should I check in for an SSIS project?

问题描述

在我的 SSIS 项目文件夹中，除了我创建的三个包 (.dtsx) 文件之外，我还有额外的文件.有一个 ProjectName.database 文件、一个 ProjectName.dtproj 文件和一个 ProjectName.dtproj.user 文件.

In my SSIS project folder I have extra files in addition to the three package (.dtsx) files that I created. There is a ProjectName.database file, a ProjectName.dtproj file, and a ProjectName.dtproj.user file.

当我构建项目时，dtsx 文件被复制到项目文件夹中名为bin"的文件夹中.

When I build the project, the dtsx files are copied to a folder called "bin" inside the project folder.

当我创建部署清单时，这三个包文件将与一个新的 ProjectName.SSISDeploymentManifest 文件一起复制到名为bin/Deployment"的文件夹中.

When I create a deployment manifest, the three package files are copied to a folder called "bin/Deployment" along with a new ProjectName.SSISDeploymentManifest file.

我应该将哪些文件签入源代码管理?

Which of these files should I check in to source control?

我认为只有三个包文件和部署清单对我有用.

I think only the three package files and the deployment manifest are useful to me.

推荐答案

您希望保留:

• *.dtsx - 您的包裹
• *.dtproj 文件 - 项目文件
• .sln 文件 - 解决方案文件 - 如果您只有一个项目，您可能没有这个项目
• *.database - 看看下面的引用
• 部署清单文件 - 允许您使用向导将包部署到目标位置

MSDN 声明如下:

*.database 文件包含 Business Intelligence Development Studio 打开 Integration Services 项目所需的信息.

The *.database file contains information that Business Intelligence Development Studio requires to open the Integration Services project.

*.dtproj.user 和 .sln.suo 文件不是必需的，因为它们(来自同一个链接):包含有关您使用项目的首选项的信息.

*.dtproj.user and .sln.suo files are not needed because they (from the same link): contain information about your preferences for working with the project.

这篇关于我应该为 SSIS 项目签入哪些文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！