Edit a dtsx through SSMS

Question

I created and executed a dtsx with SSMS corresponding wizard:

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

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

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

Is there any way I can do it, using SQL Server Management Studio?

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

Where I cannot edit the mappings any more.

Update:

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.

Answer 1

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

• Download and install SQL Server Data Tools (SSDT) for Visual Studio

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

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.

Answer 2

No, I'm afraid not. The only way to edit .dtsx files is with SSDT/Visual Studio.