Questions tagged [visual-studio-2019]
9 questions
1
vote
1 answer
Debugging T-Sql code using Visual Studio 2019. Error message: frame not in module
DBAs,
Has anyone had success using Visual Studio 2019 for debugging T-SQL code, the way SSMS allows Step-into & Step-over?
When I hit debug (Alt-F5), gives me this error, after making some progress. Looks like once it hits the section of the code…
ToC
- 727
- 1
- 8
- 20
0
votes
1 answer
SSDT db-project compare throws "source schema drift detected" for members of sysadmin
We are using SSDT database projects where changes will be done in the dev-DB, then a compare is done between the devDB and the VS-DBproject and selected changes is updated into the VS-project. Lately (maybe for about a month) the update of the…
GHauan
- 615
- 8
- 24
0
votes
1 answer
How can I downgrade an SSIS project for use with VS 2017 standalone?
I inherited a project that was being built in VS 2019. After I finished building it and asked the requestor for clarification on how to handle a few scenarios I get a warning that the license for VS 2019 is about to expire. Turns out the project was…
0
votes
0 answers
Visual Studio Data Tools (SSDT) schema comparison tool does not match database objects
I am using Visual Studio Pro 2019 (16.9.4) and SQL Server Data Tools (16.0.62103.10080) but this happens since the beginning of Visual Studio 2019.
I use the Schema Comparison tool to compare databases/dacpac vs SQL projects. And everything goes…
Alex
- 101
- 1
0
votes
0 answers
SSIS Dynamically Loop through SQL Tables
I have been fighting with an SSIS package for sometime now.
I did successfully build a package that will extract data from a specific table by creating a date list from a script task, use a forEachLoop container to loop through the date list…
Stockburn
- 501
- 4
- 22
0
votes
1 answer
What is causing BETWEEN to be replaced with <= and >=?
We have a Visual Studio solution for our SQL Server 2019 database, and it is stored in a git repo. One table has a couple of check constraints using the BETWEEN operator, like this.
CONSTRAINT chk_FileTbl_MonthlyDate CHECK (MonthlyDate BETWEEN 1 AND…
SQLDoug
- 247
- 3
- 7
0
votes
0 answers
Where does master.dacpac come from in VS 2019?
We have some build tasks that run and for the life of me I can't figure out why the ms build tools isn't installing the master.dacpac file needed for the master and system dacpac files.
Here's where it lives now:
C:\Program Files (x86)\Microsoft…
rdelgado-incinc
- 1
- 1
0
votes
0 answers
SSIS not able to run package in SSMS
It's very simple package, running fine when executed via visual studio. From the report I get:
Visual Studio 2019 Community
SQL2019CTP3.1
In the connection manager I am using windows authentication. The package has the following structure:
OLE…
gotqn
- 4,348
- 11
- 52
- 91
-2
votes
2 answers
How to join two tables and rename the new table?
I want to join two tables in sql and want to connect it with my .net project where I used web forms. help is needed. thank you
