Import DTSX package into VS project

Question

Hello! I would like to edit and run a DTSX package created on an older SQL Server (2012) in a "new" SQL Server 2019 SSIS project. Requirements: I have an MS SQL Server 2019 running (on a Windows 2019 DataCenter Server). VisualStudio 2017 (Microsoft SQL Server DataTools [SSDT]) is installed on the SQL server. In VisualStudio I created a new Integration Service Project (SSIS). But I can't find a way to import the DTSX package so that I can display the individual objects graphically and edit them again. When I open the DTSX package by double-clicking it in Visual Studio, I get the individual objects, data connections, etc. displayed correctly, but I cannot run the project (only Append instead of Run is offered) or save it as a (new) SSIS project.

How can I transfer the DTSX package back into an SSIS project?

Answer 1

Hi @Maik Smith, You may add the package by right click the SSIS packages tab.

Integration Services (SSIS) Projects and Solutions

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

But I can't find a way to import the DTSX package so that I can display the individual objects graphicall

In SSDT right-mouse click on "SSIS Packages" => "Add existing package"

Answer 3

Hello ZoeHui, Hello Olaf When I created a new project, the SSIS Packages entry was missing, so I didn't get any further. After I created another new project and had the SSIS entry, adding an existing DTSX package worked correctly. Thank you for the solution!!!