Questions tagged [visual-studio-2019]
The visual-studio-2019 tag has no usage guidance.
11
questions
0
votes
0
answers
11
views
Looking for step by step instructions on how to set up Microsoft Connector for Oracle
I am trying to use SSIS to extract data from an Oracle database. My environment is:
SQL Server 2019 Developer Edition
Visual Studio Community 2019 CU 16
SQL Server Integration Services 16.0.845.0
SQL ...
0
votes
1
answer
75
views
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 ...
0
votes
0
answers
45
views
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 ...
- 101
0
votes
0
answers
118
views
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 ...
- 425
-2
votes
2
answers
562
views
How to join two tables and rename the new table? [closed]
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
0
votes
0
answers
2k
views
RDLC report not working after upgrading from Visual Studio 2008 to Visual Studio 2019 with SQL Server 2016
After RDLC report updated with Visual Studio 2019 is not working with SQL Server 2016:
Microsoft.Reporting.WinForms.LocalProcessingException
HResult=0x80131500
Message=An error occurred during ...
1
vote
0
answers
409
views
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 ...
- 565
0
votes
1
answer
23
views
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 ...
- 227
1
vote
0
answers
164
views
IntelliSense is not woking SQL Server 2017 [closed]
I am using SQL Server 2017 and I had already installed Visual Studio 2019 before installing SQL Server. Sometimes when I create the first table in a database it gives me IntelliSense for that first ...
- 107
0
votes
0
answers
420
views
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 ...
0
votes
0
answers
386
views
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. ...
- 3,639