Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
129 questions
0
votes
0
answers
16
views
Error in Visual Studio when running a SSIS package
I need to export data from Oracle to SQL Server.
To do this, I have built a dtsx package in SQL Server 2019.
I am using Visual Studio 2019 (64bit) and an SSIS solution.
On Oracle I use "Oracle in ...
0
votes
0
answers
95
views
SQL71501: User: [user1] has an unresolved reference to Login [user1]
SQL Server DB Projects - when created generates the SQL Users scripts, which aren't associated with any SQL Logins but only to DB, without the condition 'WITHOUT LOGIN' and so leading Build error as ...
- 81
1
vote
0
answers
130
views
Does BimlExpress still support Visual Studio?
We heavily use BIML in our data projects for the development of SSIS packages, so BimlExpress is important to us.
So far, it looks like BimlExpress does not provide an installation for Visual Studio ...
- 23
-1
votes
1
answer
80
views
SQL Server comparison in VS does.. nothing?
I am using a script to copy data from a subset of tables in one server to a second server, such that the second server has fewer tables than the original. Data should otherwise be identical.
I ...
- 222
0
votes
0
answers
40
views
In a Visual Studio VB.Net project, how can SQL connection parameters be saved for repeated use?
When working with SQL files in a VB.Net project, how can the connection parameters be saved for easier development?
There are SQL files in the project, to hold queries for use in the app. When one of ...
- 147
0
votes
0
answers
70
views
How do I feed the output arrow (`Input0_ProcessInputRow()`) of a second Script Component with data from a temp table of the first Script Component?
Here is the full setup and code that takes up this answer at DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table ...
- 336
0
votes
1
answer
63
views
SSIS project window turns white right at the beginning of debugging, status "Running", tricky to get the project back. How do I avoid this crash?
This takes up SSIS package with status running is not running - Stack Overflow.
SSIS project window turns white right at the beginning of debugging, status "Running":
Right click closing ...
- 336
0
votes
1
answer
84
views
The debugger only stops at the breakpoints of the first Script Component. How do I debug more than one Script Component in an SSIS Data Flow Task?
This takes up How to debug a script component in SSIS - Stack Overflow which was asked for the 2008 version and is now outdated. That is why this question needs to be revived for the versions of ...
- 336
0
votes
1
answer
161
views
DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table alive?
Links
This takes up:
Using temporary tables in SSIS flow fails - Stack Overflow
Is it possible to use a temp table in a data flow source?; answer is:
'No', since it cannot be passed without being ...
- 336
0
votes
2
answers
759
views
How do I create and fill a temporary table with incoming data from a Data Source item without leaving the SSIS Data Flow Task C# Script Component?
I came to ask this question after coding in a script component for some time, testing mainly how to loop over columns of the Row object, see Looping Through Columns in SSIS Script Component - Stack ...
- 336
1
vote
0
answers
56
views
How would I connect to a SQL Server (running in a VM using Ubuntu Server), using Access or Visual Studio on my host?
I have tried to connect various ways already and have not been successful. I need a more specific guide on how to/if you can connect this way. I have specific limitations that you need to account for, ...
- 9
0
votes
1
answer
66
views
Does DACPAC creation is doing any blocking on database / server level?
I have to create DACPAC from production database. I would like to do this via Visual Studio 2022 (SQL Server Object Explorer and "Extract - Data-tier application"). Is it possibility to ...
- 421
0
votes
0
answers
52
views
Visual Studio SQL Data compare: equal records, but it flag as delete/add
I'm comparing two table's database data, using Visual Studio SQL Data compare, updating target.
Once it finished, I do rescan, and it show me delete/add on some rows, even if the are the same:
Why ...
- 243
1
vote
1
answer
39
views
How can I get PostgreSQL to follow up filtering jobs that my FDW ignored?
I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C.
It seems to be working rudimentary, but I have one problem.
When I pass it a query like the following via psql:
select * from ...
- 33
3
votes
1
answer
7k
views
Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite
I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://...
- 143
1
vote
1
answer
103
views
where/how do I specify sql server file groups in visual studio?
I see that there is a drop down list box in in the project properties to chose the default file group but PRIMARY seems my only choice
Where can I define other File groups?
- 123
0
votes
1
answer
668
views
SSIS OLE DB Destination REPLACE instead of INSERT
The information flowing from an OLE DB Source to an OLE DB Destination is getting inserted, allowing duplicate records to be submitted after the package is run.
Is there a good way to replace these ...
- 3
0
votes
1
answer
203
views
Reading from .sql file located in Visual Studio repository
A user.sql file which contains
USE [database]
GO
-- Legacy users cleanup
DROP USER IF EXISTS [dw];
etc...
is located at the repository: https://company.visualstudio.com/Database/_git/Azure?path=etc...
...
- 371
1
vote
0
answers
2k
views
SQL server job agent fails to execute SSIS package, the package runs fine manually
I have a job which executes two packages. Step 1 is a package which is no longer executing under the job agent although it was executing fine before the server reboot. The package executes fine ...
9
votes
1
answer
11k
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 ...
- 193
1
vote
1
answer
3k
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
310
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
1
answer
3k
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. ...
- 147
0
votes
0
answers
450
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
685
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
3k
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 ...
- 143
2
votes
1
answer
100
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
465
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
2k
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
1k
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
1k
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
2
votes
1
answer
28k
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 ...
- 133
0
votes
1
answer
1k
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
5k
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
3k
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
89
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
325
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
2
answers
885
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
688
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 ...
- 31
5
votes
1
answer
2k
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 ...
- 468
0
votes
0
answers
581
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
237
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, ...
- 101
0
votes
1
answer
48
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
2
votes
0
answers
652
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 ...
- 161
0
votes
1
answer
1k
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 ...
2
votes
0
answers
430
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=...
- 804
1
vote
1
answer
8k
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
...
- 207
3
votes
1
answer
2k
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. ...
2
votes
2
answers
6k
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 ...
- 121
3
votes
1
answer
5k
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