3

When I installed VS2019 Express I made sure to include the Data storage and processing Workload, I also created an SQL Server Database Project, but when I add the .dtsx (SSIS) file to my project it still doesn't open in the GUI. I know there is GUI information included in the file because I can see the XML character entities where separate diagram XML is written with them.

There also appears to be something that looks like a .NET assembly in there with some C# code and some kind of Base64 encoding, who knows if it's zipped or what kind of file or string it contains.

I've looked at the XML within the file, and I'm fairly certain I understand what it does, but it's a rather convoluted xml file so I'd like to use VS2019 Express to find out for sure what it does using the GUI.

Are there any other dependencies I need to install?

This older question has some answers in it, but I don't see of the things they mention listed in the Individual Components on the installation screen.

Hadi
  • 36,233
  • 13
  • 65
  • 124
leeand00
  • 25,510
  • 39
  • 140
  • 297
  • Ah, so it's the basic Microsoft people know how to use this, so lets make it do the same thing, but rename it to six or seven different things that do the same thing. – leeand00 May 15 '19 at 12:28
  • 1
    i suggested editing the question title to be more abstract since this question is widely asked (changes are made in latest version) and an abstract title will prevent others to ask the same question multiple time. similar question: https://stackoverflow.com/questions/56080651/visual-studio-2019-ssdt At the end, you're the original poster and you have the right to reject my edit. Good Luck – Yahfoufi May 15 '19 at 14:22

1 Answers1

1

I think you should download and install the Integration Services Projects extension:

Refering to the following documentation:

For Analysis Services, Integration Services or Reporting Services projects, install the appropriate extension(s) from the marketplace (What you need to install)

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • 2
    You will also need to install the SQL Connection manager that is referenced in Known issue #1 from the SSIS Marketplace link that Hadi provided. – J Weezy May 16 '19 at 02:31