如何编辑 SSIS 包文件? [英] How do I edit SSIS package files?

问题描述

我在接手的项目中有一个 DTSX 文件.我有 Visual Studio 2005 Pro，但它只是将它作为 XML 文件打开.SQL Server Management Studio 2005 也是如此.

I have a DTSX file in a project I'm taking over. I have Visual Studio 2005 Pro, but it just opens it as an XML file. SQL Server Management Studio 2005 does the same.

我见过有人以某种工作流格式打开这些文件；我想到了商业智能开发工作室.

I've seen people opening these files in some workflow-esque format; Business Intelligence Development Studio comes to mind.

这是 Visual Studio 还是 SQL 的一部分?需要单独购买吗?我可以使用我拥有的工具以更有用的方式打开此文件吗?

Is this part of Visual Studio or SQL? Does it have to be purchased seperately? Can I open this file in a more useful way with the tools I have?

推荐答案

来自商业智能工作室:

文件->新建项目->集成服务项目

File->New Project->Integration Services Project

现在在解决方案资源管理器中有一个 SSIS Packages 文件夹，右键单击它并选择添加现有包"，会有一个下拉菜单可以更改为文件系统，最底部的框允许您浏览文件.请注意，这会将文件从任何位置复制到项目的目录结构中.

Now in solution explorer there is a SSIS Packages folder, right click it and select "Add Existing Package", and there will be a drop down that can be changed to File System, and the very bottom box allows you to browse to the file. Note that this will copy the file from where ever it is into the project's directory structure.

这篇关于如何编辑 SSIS 包文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！