2,083 questions
0
votes
0
answers
30
views
error MSB4226 Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found when running GitHub actions build on a selfhosted Windows Runner
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....
1
vote
0
answers
164
views
Using non hard-coded values for test conditions within VS SQL Server Unit Test Project
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 ...
0
votes
0
answers
65
views
Random Change tracking enabled error when deploying `DACPAC` using `DacFx`
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 ...
0
votes
1
answer
92
views
How do I get Visual Studio Code to restore and build SSDT related projects in a solution?
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(...
0
votes
1
answer
46
views
Unable to open / upgrade SSDT 2015 package in Visual Studio SSDT 2022
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:
...
0
votes
1
answer
71
views
Using SSDT, how to reference a second database via DacPac where the schema in the four part name is a parameter?
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 ...
-1
votes
1
answer
107
views
Visual Studio database project dacpac reference errors
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 ...
0
votes
0
answers
116
views
Is DTExec.exe and SSIS backwards compatible?
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 ...
0
votes
0
answers
139
views
Which Visual Studio 2022 edition should I select for using SQL Server Data Tools?
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 ...
-1
votes
2
answers
715
views
Existing SSIS package not loading correctly in newer version of Visual Studio
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 ...
0
votes
0
answers
20
views
How can I get a list of the servers and databases in SSOX (SQL Server Object Explorer)?
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 ...
0
votes
1
answer
138
views
"Schema Comparison" in VS2022 ignores "Ignore keyword casing"
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 ...
0
votes
0
answers
96
views
Access Drivers support end dates and upgrade options for SSIS in newer Visual Studio versions
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 (...
0
votes
0
answers
34
views
Exclude files from the build when wildcard include is used (SDK SSDT project)
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 ...
0
votes
1
answer
51
views
SQL Server Object Explorer, set focus on table from Query
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 ...