Problem Description I'm unable to use the Slowly Changing Dimension Wizard in Visual Studio 2022 with SSIS. I get different errors on subsequent attempts: First attempt: Method does not exist. (...

We have a SQL Server Data Tools (SSDT) Visual Studio database project, and we deploy the DACPAC output using DacFx + PowerShell scripts. In this project, we enable: Database-level change tracking via ...

I am able to create an SSDT solution, with projects, and build in VS Pro 2022 without any issues. However, when I do the same in VS Code, I get the following warning: Restore succeeded with 1 warning(...

Currently all of our SSDT packages have been created with SQL Server Data Tools 2015 We are looking to upgrade to SSDT 2022. I installed Visual Studio 2022 with the following selected during setup: ...

I have a scenario where my SSDT project needs to reference a second database via Dacpac, but the destination schema could change per environment. In the example below I have my primary database with a ...

We have a Visual Studio SQL server data tools solution with multiple databases for an on-premise database server. Our datawarehouse database references many of the source databases which have been ...

We have hundreds of SSIS packages created with Visual Studio 2015 and currently they all run perfectly fine through batch commands that execute the following: C:\Program Files (x86)\Microsoft SQL ...

To create Integration Service packages before, I could set up the development environment without caring about Visual Studio edition. Because the shell copy of Visual Studio 2017 was apparently ...

I am in the process of updating our local instance to SQL Server 2022. I have all of the SQL Server configuration done, but I am having problems getting our SSIS packages to open in Visual Studio and ...

I am writing a VS extension for VS 2022 and want to retrieve a list of servers/databases in SQL Server Object Explorer. This window is provided by (I believe) SQL Server Data Tools. It is not the same ...

I can't upload the Image to SO for some reason so see the imgur screenshot here#1 and here#2 and here#3. [edit] In 3rd example, the only diff emphasis is on the keyword CREATE (casing problem) while ...

We are currently using Visual Studio 2017 and have several SSIS packages that were originally developed in older versions of Visual Studio. These packages utilize Microsoft Access Database Engine (...

There are several *.sql files in the projects that are excluded from the build (Build = None). I would like to use <Build Include="**\*.sql" /> include type for the objects, so I'll ...

I have setup a connection to my local SQL Server, over the "SQL Server Object Explorer" in Visual Studio. Is there a way, built in or maybe with an extension, for setting the focus to a ...

The whole plan is to create dacpacs in linux docker container. I saw that there is dotnet msbuild option, however when I try to build the project it complains that it can't find Microsoft.Data.Tools....