通过SSMS编辑dtsx [英] Edit a dtsx through SSMS

问题描述

我使用SSMS对应的向导创建并执行了dtsx:

I created and executed a dtsx with SSMS corresponding wizard:

这是为了在现有表中导入平面文件.

This was to import a flat file in an existing table.

最后，我将程序包"另存为.dtsx文件

At the end I saved the "package" as a .dtsx file

现在，我需要修改列映射，然后重新执行此程序包.

Now I need to modify the column mappings and re-execute this package.

是否可以使用SQL Server Management Studio做到这一点?

我尝试打开文件，但它打开了此对话框:

I tried opening the file, but it opens this dialog:

我无法再编辑映射的地方.

Where I cannot edit the mappings any more.

更新:

我知道编辑" dtsx不是一件容易的事，但是有没有理由无法使用已设置的值再次运行该向导吗? 就像在最后一步中打开向导一样，然后在上一步中返回".毕竟这是现有功能...

I understand that "editing" a dtsx is not a simple thing, yet is there a reason why the wizard could not be run again with the values already pre-set? Like opening the wizard in the last step and navigate "back" on the previous steps. This is existing functionality after all...

我有什么办法可以做到这一点吗?从命令行也许?这可以满足我的需求.

Is there any trick I could do this? From command line maybe? This would suit my need fine.

推荐答案

编辑.dtsx包的唯一方法是使用Visual Studio的SQL Server数据工具(旧版本的Business Intelligence Development Studio)

The only way to edit .dtsx packages is using SQL Server Data Tools for Visual Studio (Business Intelligence Development Studio in older versions)

• SQL Server Management Studio可以管理和计划程序包的执行，而不是在程序包"的编辑位置.

  SQL Server Management Studio can manage and schedule package execution it is not where Packages are edited.

  在执行程序包之前，您可以在SSMS中编辑一些配置，例如更改连接，传递参数值，分配变量值和其他一些选项.

  There are some configurations that you can edit in SSMS before executing the package like changing connections, passing parameters values, assign variables values and some other option only.

  这篇关于通过SSMS编辑dtsx的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！