Open a dtsx file in design view?

x x 1 Reputation point
2022-11-21T00:24:04.25+00:00

Hello, I just installed Visual Studio 2022 on my server. Issue is when I open a .dtsx file it looks like it does in SQL Management Studio. How can I get Visual Studio 2022 to go into design view? When I Googled it everything says go to solution explorer and do it from there. Issue is it has nothing in it after I open the .dtsx file. Last time I used VS was back in 2008. Sorry I'm a huge noob with VS. Just trying to go into design view.

Thanks for any help.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,604 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,702 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 27,266 Reputation points Microsoft Vendor
    2022-11-21T05:44:00.93+00:00

    Hello @x x ,

    Welcome to Microsoft Q&A forum.

    To view the design view is easy, you just need to right-click the .dtsx file in solution explorer and then click "View Designer". The design view of this .dtsx file will display in Visual Studio.

    BTW, SSIS extension is still not available for VS 2022 currently(just as a tip if you want to use SSIS in VS 2022).

    Example screenshots:

    262270-image.png

    262358-image.png

    262260-image.png

    • Update1:

    In short

    The View Designer feature for .dtsx file needs SSIS extension’s support, but the extension isn’t available for VS 2022 currently, so you cannot go into design view(.dtsx file).

    Workaround(s)

    You may try to use VS 2019 and follow the steps above to go into design view or wait for SSIS extension to support VS 2022. Please kindly check @Yitzhak Khabinsky ’s answer below.

    Long story

    First of all, based on the message from here(SQL Server Integration Services Projects Q&A):

    263335-image.png

    SSIS extension will be available for VS 2022 at the end of this month. So SSIS extension is not available for VS 2022 currently.

    Then to open and view the design view of a single .dtsx file in VS 2022, it is needed to install and use the SSIS extension for VS 2022, so you will not find the option to open the design view, currently in VS 2022.

    Normally, in VS 2022, if you click File > Open > File… > select the .dtsx file > Open, you should see a very similar "blank" Solution Explorer:

    263372-image.png

    But only xml codes are available, there’s also no View Designer option.

    For what you have seen => Solution Explorer is totally blank, I’m not sure, did you perform the same operations which I mentioned above to open this single .dtsx file? If you use other ways to open this file, please feel free to let me know.

    Best Regards,
    Tianyu

    • If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
      Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
  2. Tom Phillips 17,716 Reputation points
    2022-11-22T13:43:51.903+00:00

    SSIS packages are referenced by a "solution" file, .sln. In VS, you want to open the .sln file, which contains references to the dtsx file(s).

    0 comments
  3. Yitzhak Khabinsky 24,946 Reputation points
    2022-11-22T13:49:49.397+00:00

    Hi @x x ,

    As @Tianyu Sun-MSFT already pointed out, VS2022 doesn't support SSIS development yet.

    To achieve what you need, you would need to have the following on your machine:

    1. Any version of VS2019
    2. Server Integration Services Projects extension for VS2019. And use its 3.16 version, and stay away from any 4. versions of it. They are experimental, have bugs, and missing some functionality.
    0 comments