Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
126
questions
-1
votes
1
answer
61
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
35
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 ...
- 137
0
votes
0
answers
23
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 ...
- 316
0
votes
1
answer
30
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 ...
- 316
0
votes
1
answer
27
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 ...
- 316
0
votes
1
answer
128
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 ...
- 316
0
votes
2
answers
324
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 ...
- 316
1
vote
0
answers
48
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
48
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 ...
- 355
0
votes
0
answers
37
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
31
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
6k
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
71
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
513
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
189
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...
...
- 361