Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
115
questions
-1
votes
0
answers
8
views
Error when browsing a cube in Microsoft SQL Server 2017
I have created a cube in Microsoft SQL Server but when I explore it I get the following message "Cannot browse cube. Check that the cube has been implemented and processed" when I have ...
- 1
0
votes
0
answers
5
views
Define custom visibility order for dimensions' attributes on SSAS and PowerBI
I'm using Visual Studio 2019 to design some datamarts on SSAS to them use PowerBI to make data analysis.
In both VS and PowerBI, dimensions and their attributes are being listed on alphabetical order. ...
- 1,413
3
votes
1
answer
2k
views
Error starting localDb on Windows 11
I installed Windows 11 on a brand new NUC, then installed all updates. Installed Visual Studio 2022 CE and SSMS (v 18.10)
I attempted to start the localDB which is assume was installed as part of ...
- 133
1
vote
1
answer
421
views
SSIS transforming numbers with decimal comma to decimal dot
I'm trying to create a very basic package that copies data from my SQL server into an Excel file.
The data that comes from the server comes with a decimal comma (e.g. 1234,56) - that is how I want it, ...
- 11
0
votes
0
answers
38
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
33
views
IDE/Plugin for inline editing MySQL data records like a regular file in its own tab
I'm using Code OSS v1.58.0. One of my projects stores HTML content in a database. I'm looking for a tool or a plugin for Code OSS that can open data records like a file.
As it were an equivalent to ...
- 101
0
votes
1
answer
65
views
How to recover missing SQL auto-recover files in SSMS (Microsoft SQL Server Management Studio) after unexpected shutdown
SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not all of them, especially one in particular. ...
- 133
0
votes
0
answers
28
views
Queried cube only returns one single value : the total value of the measure
I have a database where not each dimension row is linked to a fact table row. For that issue, and in order for me to deploy the cube, i set the UnknownMember of the dimensions to be Visible and ignore ...
0
votes
0
answers
158
views
Cube won't deploy
I was able to deploy a large cube (with 2 dimensions and 1 measure) in Analysis services server but only after setting configuration error options for both dimensions and the measure (through the ...
0
votes
2
answers
138
views
Is there option to build dacpac only when there are changes? [closed]
I'm using Visual Studio 2019 to build sql project.
The issue is that building and deploying the dacpac to our database takes up most of our deployment time, when a lot of times, there are no changes ...
- 101
1
vote
1
answer
596
views
Visual Studio Data Tools (SSDT) schema comparison tool seems like it's not working correctly
I recently started using the SSDT schema and data and comparison tools. For years I was using Red Gate's SQL Compare and SQL Data Compare, but I figured the VS tools are probably enough and figured I ...
- 113
2
votes
1
answer
32
views
Identifying elements in SSIS package built in MS Visual Studio 2008
I recognize that these are variables, but I am not sure how to add these elements to the package (or how they are added to begin with), what effect that have or even how to manipulate them. No right ...
- 75
2
votes
1
answer
126
views
Annotations for SSIS
Forgive me if this is an inappropriate question for this forum (being DBA and all, I thought it may fit).
I have an SSIS package that I've recently upgraded and moved from BIDS to VS 2019.
It's a very ...
- 188
0
votes
1
answer
710
views
SSIS cannot deploy package to SQL server - An error occurred during decryption 15466
After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
=============================...
- 101
-1
votes
1
answer
186
views
Excluding database objects from a DacPac database deployment?
As I understand it, a sql server DacPac (visual studio data-tier app) applies to the entire database that it's deployed in. However, for my particular database, I have some tables and stored procs ...
- 163
0
votes
2
answers
148
views
How do I copy a SQL Server Database Schema and Objects between servers using VS2019
I've inherited a database with about 1500 tables, and 3600+ objects overall. I want to copy the schema - and just the schema - across to a different server, where I can get it into source control (TFS)...
- 1
1
vote
1
answer
6k
views
MySQL - "Visual Studio must be installed" - but it is?
When using the MySQL installer, it says "Visual Studio version 2015, 2017 or 2019 must be installed".
I have installed Visual Studio 2019 and "MySQL for Visual Studio", but it ...
- 123
0
votes
1
answer
631
views
I am getting this error : "Error 102 : non-boolean type specified in a context where a condition is expected" for this request : [closed]
private void button2_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "delete from MYDB ...
- 1
0
votes
2
answers
2k
views
How to find a list of local MS SQL Servers?
I looked at How can I determine installed SQL Server instances and their versions? already but CMD returns nothing:
C:\Windows\system32>sqlcmd -L
C:\Windows\system32>
But when using Visual ...
- 103
1
vote
1
answer
1k
views
In a DacPac deployment, if a stored procedure that is called by another stored procedure is updated, is the calling stored proc also redeployed?
I noticed that, in my DacPac, after a deployment, two stored procs were given a modified date on sys.objects, almost to the same millisecond. However, I would only expect one of them to have this, ...
- 163
-1
votes
1
answer
32
views
invalid syntax and invalid column
first picture i dont know why i keep getting this error i have no idea how to fix it...either i get this error or invalid column name -_-
the invalid column error i get only on the item 'tosai'
this ...
- 1
0
votes
1
answer
26
views
Does visual studio (2015 or above) needs to be installed in a server in order to transfer/create SSIS packages there?
At work we have an old server and we're moving everything from there to our new server. We're a very small team, and one of my team-members says without visual studio 2015 in the new server he can not ...
- 1
0
votes
1
answer
159
views
SSRS Report returning old data
I have created and tested a report in Visual Studio and it returns data from a SQL server database.
Once uploaded to SSRS, the report returns old data.
What would I need to check as it appears the ...
1
vote
0
answers
133
views
SSDT Schema Compare shows same objects to add and delete in destination
When using schema compare, it shows the objects in dbo schema as objects to add in destination and same objects to delete as well. After inspecting the definitions, they appear to be the same. Why ...
- 11
2
votes
1
answer
910
views
SQLPackage resets database recovery model
I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it ...
- 430
0
votes
0
answers
384
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
110
views
Add SQL Server Level Login in master Database using Visual Studio 2019
I'm trying to add sever login in Azure SQL Server using Visual Studio 2019 SQL Project with SSDT and deploy it using Azure Devops by building CICD pipeline. The rest database object (e.g. tables, ...
0
votes
1
answer
42
views
Aggregating data in .net SQL
I'm converting a database originally written in MS Access VBA to .net and many of the SQL statements that worked in Access don't work in .net. My data set is standard stock market daily information ...
- 1
1
vote
0
answers
232
views
VS 2019 - Schema Compare - "The certificate chain was issued by an authority that is not trusted" when TrustServerCertificate=True
I'm trying to do a schema compare in VS 2019 with Active Directory Password Authentication. The account I'm using works in SSMS, but fails in VS with the following error, even when ...
- 151
0
votes
1
answer
946
views
I gave 3 large Excel files need to be loaded in Single SQL table
I have 3 large Excel files each sized 56896 KB, I need to load all 3 files into same SQL table. what is better way to handle?
since My excel has more data, my excel hang up when I open and search any ...
1
vote
0
answers
249
views
SSRS 2016 / VS 2015 Editing text in tablix's textbox very slow in designer
Same issue as described here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6bf89cd-75de-49f9-8a3a-743419ecd631/ssrs-2016-editing-text-in-a-textbox-very-slow-in-the-designer?forum=...
- 764
1
vote
1
answer
5k
views
How to change "deployment target version" on SSIS 2019?
I am experiencing the following errors when using the "Transfer SQL Server Objects" task in SSIS on Visual Studio 2019:
An exception occurred in SMO
Value cannot be null. Parameter name: server
...
- 177
3
votes
1
answer
1k
views
Publishing database changes with SSDT that include adding columns to existing table to the target database through Project
Publishing database changes with SSDT that include adding columns to the existing table in the target database(which was previously created through SSDT).Instead of creating a new SSDT database. ...
1
vote
2
answers
4k
views
Visual Studio Code Postgres SQL Connection
I would like to use Visual Studio Code to preform my PostgreSQL queries, and general DB maintenance as an alternative to pgAdmin4. I have read the documentation included with the appropriate extention ...
- 11
3
votes
1
answer
3k
views
SSIS : Null value for date keeps failing
I have a sequence container and in that sequence container I have select that is passing through data into a foreach loop container. The problem arises with one of the columns that's a date datatype. ...
- 67
0
votes
1
answer
1k
views
Drop and Recreate All Objects in Database Project
I have a database project in Visual Studio Team Services Git, and want to deploy into database on actual server.
(a) Is there setting in publish profile, to drop all objects and recreate?
(b) or is ...
user172734
3
votes
1
answer
1k
views
What does @RC mean in SSDT SQL Server Unit Testing?
In Sql Server Unit Testing, SSDT, what does @RC stand for? Does it mean Row Count, or Row Column? Team wants to understand, we have been using it for long time, good tool which works, just curious.
user173948
2
votes
0
answers
20
views
SSRS Web Reference Service Not Found
I'm attempting to add a Web Reference to my Visual Studio Web API to link my existing SSRS server to said API. I'm on the Add Web Reference page and I enter the proper URL and the webpage appears in ...
- 121
0
votes
1
answer
2k
views
SSRS Rectangle visibility based on Parameter Value
I am creating a Report in SSRS.
Its a Dynamic 2011 CRM Report.
I have created some Tables.
And some Rectangles.
Each Rectangle contains some Tables.
Also there is a Parameter that contains value from ...
0
votes
1
answer
45
views
Visual Studio extract database values to excel with header text!
I am trying to extract the values from an mdf database to excel, but i can't display the header texts(title fields). I can only view the values. In order to make this work i need a query like this ...
1
vote
1
answer
94
views
SQL how to remove duplicate results from same table
I created an sql table on visual studio for visual basic, where i can put dynamic data every time i click on a button. I get the table results from textboxes and one datagridview with values(quantity,...
1
vote
0
answers
4k
views
'The INSERT statement conflicted with the FOREIGN KEY constraint
I am wanting to add insert into my uspInsertUserRoles procedure:
CREATE PROCEDURE [dbo].[uspInsertUserRoles]
@RoleID INT,
@UserID INT
AS
BEGIN
INSERT INTO tblUserRoles(RoleID, ...
- 11
1
vote
1
answer
793
views
Visual Studio SSDT Ignore Query Store Options in Publish Profile
Is there any way in Visual Studio SSDT Publish Profile, to Totally Ignore Query Store Options Completely?
It keeps asking us to Rerun publish code below. I go to Database advanced settings, and turn ...
user162241
3
votes
1
answer
269
views
SQL Visual Studio Find and Replace in Publish Profile
We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References.
We need Project references, since ...
user162241
5
votes
1
answer
547
views
Reinitialize Table Values in SQL SSDT Unit Testing
I am creating SQL Server Unit Tests. We are testing various stored procedures.
In Unit testing principles, it is good practice to setup a small database table, populate values, and tear down (...
user162241
3
votes
1
answer
594
views
Make SQL Server SSDT Database Project Reference Different in Publish Profile
In a SSDT Database project, I know how to publish the Self-Database to different locations. I can change eg, the Customer database name in the Publish profile.
Example
In:
Dev Environment: will ...
user162241
1
vote
1
answer
531
views
View with OPENQUERY won't build in SSDT project
I have an existing database that I'm trying to set up as a database project. I'm not able to get the following statement to build:
CREATE view [dbo].[VW_SOMEVIEW] as
SELECT * FROM OPENQUERY ([...
- 33
1
vote
1
answer
1k
views
Unable to find "Local" window while debugging SSIS package
I'm trying to debug my package in SSIS. I need to see the value of my variables while debugging, but the problem is that I cannot find the "Local" window. The only window I have is the breakpoint ...
user157749
-1
votes
1
answer
2k
views
Foreach Loop Enumerator with multiple File Names
I have a directory like C:\NewExcelFile in which I have lots of different Excel files with different names (but with the same extension .xlsx). I have a "foreach loop enumerator" in my package which I ...
user157749
0
votes
1
answer
194
views
Precedence constraint does not run in SSIS package
Hope you are doing well.
I have a Precedence constraint that does not work . Putting it into more clear way , the package is executed successfully up until the components in which I have the ...
user157749