Normally you can use the batch update property feature of BIDSHelper, as explained in this blog post by Cathrine Wilhelmsen. But you’d have to do this for every package in your project. Opening a package, clicking on the protection level property and saving the package fixes the issue for that package. Both the project and the packages are set to DontSaveSensitive. Another issue is that when I tried to deploy the project, I got build errors saying the protection level between the project and the package were not the same. This might be because the extension is still in preview, but I’m not sure. However, when I changed the TargetServerVersion property of the project, I noticed there’s only 20 available. I could open an existing project (saved as a SSIS 2019 project) without issue. It’s possible you’ll have to restart the machine after the setup finishes: You only have to choose into which installation of VS you want to install the extension, but normally there aren’t that many options to choose from.Ĭlick Install and wait for a few minutes. 450MB), you can start the setup and it’s a real “next-next-finish” setup, as there’s nothing to configure. Anyway, install VS 2022 on your machine and download the SSIS extension here.Īfter the download (approx. The good news is that you can use the community edition of VS if you’re just using it for BI development.
So you’ll need a full-blown version of Visual Studio (make sure you only install the workflows you actually need). SQL Server Data Tools (SSDT) is no longer available as a separate download. SSAS and SSRS have been available for some time now in VS 2022, but the extension for SSIS has only just been released in preview.įor those of you that have been working on an older version of SSIS/SQL Server (2014-2016, something like that), the BI components (SSIS/SSAS/SSRS) are now extensions in Visual Studio.
The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022.
0 kommentar(er)
