Skip to main content
0 votes
0 answers
30 views

I'm building a selfhosted github runner image using a docker file. When we run a github actions build on this runner I get the following error: MSBuild auto-detection: using msbuild version '18.0.5....
checkcomparemeerkat's user avatar
1 vote
0 answers
164 views

Is it possible to use non hard-coded values for asserting scalar values in VS SQL Server unit test project? Below I have the variable @ResourceId that I'd like to test against the value of a column ...
user32056484's user avatar
0 votes
0 answers
65 views

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 ...
Indi's user avatar
  • 33.9k
0 votes
1 answer
92 views

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(...
J Weezy's user avatar
  • 4,069
0 votes
1 answer
46 views

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: ...
JetRocket11's user avatar
0 votes
1 answer
71 views

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 ...
Sam Alex's user avatar
  • 121
-1 votes
1 answer
107 views

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 ...
Koen van Wielink's user avatar
0 votes
0 answers
116 views

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 ...
JetRocket11's user avatar
0 votes
0 answers
139 views

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 ...
saya24's user avatar
  • 57
-1 votes
2 answers
715 views

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 ...
Scotty Smith's user avatar
0 votes
0 answers
20 views

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 ...
Ann L.'s user avatar
  • 14k
0 votes
1 answer
138 views

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 ...
CodeAngry's user avatar
  • 13.1k
0 votes
0 answers
96 views

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 (...
Satya J's user avatar
0 votes
0 answers
34 views

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 ...
Dmitrij Kultasev's user avatar
0 votes
1 answer
51 views

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 ...
Dom84's user avatar
  • 866

15 30 50 per page
1
2 3 4 5
139