Import DTSX package into VS project

Maik Smith 21 Reputation points
2024-01-18T14:06:23.0133333+00:00

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. DTSX-Paket

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

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author
ZoeHui-MSFT 41,551 Reputation points
2024-01-19T02:00:21.92+00:00

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

Integration Services (SSIS) Projects and Solutions

Regards,

Zoe Hui


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

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 47,631 Reputation points
    2024-01-18T14:12:04.67+00:00

    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"

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

  2. Maik Smith 21 Reputation points
    2024-01-19T10:02:28.92+00:00

    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!!!

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.