Search code examples
sql-serverssisssmsetlsql-server-2016

Edit a dtsx through SSMS

I created and executed a dtsx with SSMS corresponding wizard:

enter image description here 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:

enter image description here

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.

Solution

  • 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 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.