Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
0
votes
1answer
31 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 ...
0
votes
0answers
6 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=...
0
votes
1answer
79 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
...
2
votes
1answer
38 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. ...
0
votes
1answer
75 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 ...
3
votes
1answer
84 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. ...
0
votes
0answers
24 views
SQL Server Integration System (SSIS): looking for a way to iterate a list of Oracle databases
I am developing a package in Visual Studio in order to bring some info coming from different Oracle databases in a unique SQL Server database. Each Oracle database is a clone of the other one, the ...
0
votes
1answer
37 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 ...
3
votes
1answer
155 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.
2
votes
0answers
11 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 ...
0
votes
0answers
14 views
Visual Studio or Report Manager for deploying SSRS Reports created using Visual Studio - Pros and Cons
Not sure if this is the best site for this question because I am looking for opinions rather than a technical answer. Sorry, in advance if this posting is not appropriate. Just let me know and I will ...
0
votes
1answer
32 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
1answer
28 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
1answer
55 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
0answers
802 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, ...
1
vote
1answer
199 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 ...
3
votes
1answer
92 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 ...
5
votes
1answer
183 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 (...
2
votes
1answer
75 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 ...
1
vote
0answers
126 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 ([...
1
vote
1answer
76 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 ...
-1
votes
1answer
552 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 ...
0
votes
1answer
49 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 ...
1
vote
1answer
1k views
Can't deploy SSAS Tabular Model in Visual Studio
I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
1
vote
1answer
174 views
Facing Error in “Execute Sql task” component (The type of the value (DBNull) being assigned to variable)
Hope you are doing well
I have a table as you can see below :
I have a variable "ExcelPath" in "SSIS" in which I keep "FilePath" column .
Then I have "Execute SQL task" and the query I wrote in ...
1
vote
1answer
444 views
How to read data from multiple Excel files with SQL Server Integration Services(New Senario)
Hope you're doing well.
I have a scenario here.
As you can see I have a table with two main columns :
What I need is to read each "FilePath" which is "Active" right now and then read the Excel files ...
3
votes
2answers
987 views
SSDT Drop and Recreate Tables when nothing has changed
We have a Visual Studio Database Project consisting of about 129 Tables. It is the primary database for our Internal Web Based CRM/Call Centre product, which is still under active development.
We ...
1
vote
1answer
29 views
Preventing SQL Server Data Tools from Inserting Spaces in Object Names
Is there any way to prevent SQL Server Data Tools and Visual Studio from introducing spaces into object names when creating dimensions, mining structures and the like from data source views (DSVs)?
...
5
votes
1answer
1k views
SSMS Crashes When Creating or Editing SSIS Packages [closed]
Problem started May 3rd. We are no longer able to import SSIS packages that have been modified by Visual Studio 2017.X into our SQL Integration Services (SQL version 2017 14.0.3023). SSMS ...
5
votes
0answers
146 views
Using the Schema Generation Wizard to regenerate a previously-generated schema
Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse.
The contractors generated ...
4
votes
2answers
129 views
Regenerating a cube relational schema in Visual Studio
I have an Analysis Services cube project that my company received from an outside contractor, and I'm trying to get it so that developers can work on it on their local machines.
I'm pretty sure that ...
0
votes
1answer
209 views
SSAS and Visual Studio Optimization Wizard does not work
We have setup and logged data on our Production Server, but when we try to run the Optimizations from within Visual Studio it crashes immediately with
TITLE: Microsoft Visual Studio
------------------...
0
votes
3answers
5k views
Can't restore SQL Server 2016 backup to SQL Server 2014 [duplicate]
We are having an issue at trying to restore a database:
System.Data.SqlClient.SqlError: The database was backed up on a server
running version 13.00.4001. That version is incompatible with this
...
5
votes
2answers
1k views
What is the best way to include SQL Server Agent jobs in Source Control?
I found that if I script a SQL Server Agent job as 'create to' that the script starts with use msdb- so I assume that jobs are stored in the msdb database?
What is the best way to add SQL Server jobs ...
2
votes
0answers
107 views
View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))
I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R
settings <- as.environment(list())
dbConnection1 <- 'Driver={SQL Server};Server=
(local)...
5
votes
1answer
16k views
“Invalid object name” error when executing query
I connect database with Visual Studio 2017. When I am trying to execute a query then it shows the following error:
The connection string I am using is:
SqlConnection con = new SqlConnection("Data ...
1
vote
0answers
35 views
Threadsafe/non-clobbering foreach file container for SSIS?
I'm attempting to modify a SSIS package in Visual Studio's "File Reader Integration Services" to process multiple ForEach File Enumerators at the same time (each for different file sub-types), but it ...
0
votes
1answer
395 views
Connecting SQL Server Developer Edition to Visual Studio Windows Forms Application
I downloaded the free SQL Server Developer Edition in hopes of being able to use SQL Server for my Visual studio project, but I can't seem to understand how to connect it. :(
In my SQL Management ...
1
vote
1answer
1k views
Installing SQL Server and Visual studio side-by-side [closed]
Is there any problems that I should be aware of when installing SQL Server and Visual Studio side-by-side? In which order should I install them?
My head tells me to install Visual Studio and then to ...
0
votes
1answer
2k views
Class not registered error in SSAS Data Source View
Has anyone come across Class Not Registered issue while opening Data Source Views in SSAS using Visual Studio 2015? There are similar posts not haven't found anything exactly the same.
Error text:
...
3
votes
1answer
583 views
SQL TFS Visual Studio Solution: One Database or Multiple Databases [closed]
When creating a TFS Visual Studio 2017 solution with SQL Server 2016, should the solution contain
one database project per solution, or
multiple database projects in a single solution?
Our system ...
2
votes
1answer
554 views
VS Database Project failed to build with post-deployment script adding agent job
I am maintaining and publishing a DBA tools database using a Visual Studio 2017 Database Project.
Now I am trying to add a SQL Server agent job using a post deployment script.
The job is scripted ...
1
vote
0answers
349 views
What is the <project name>.sqlproj.user file, and how is it created?
I want to move a .sln file to a directory above where it is currently located (because right now it's in a project directory, which isn't semantically correct). The project is called 'pName', and ...
3
votes
1answer
413 views
Why is the 'AS' table alias keyword required in Visual Studio (Database projects)
Up till now I have been working directly on SQL Server instances, and am now playing around with how best to keep databases in source control. The visual studio database project seems to be exactly ...
0
votes
1answer
80 views
Reportviwer matrix show all months/weeks of year
I'm new here, and i have a situation.
I need to alter one report that i created a few time ago, that shows the planning of maintenance. But not all months/weeks have plan defined, and i want to show ...
0
votes
2answers
848 views
Red Gate SQL Prompt in Visual Studio not working?
I have tried out SSDT Database project in Visual Studio, and with the SQL Prompt solution from Red Gate. It seems that the intellisense only works for SQL keywords like SELECT, WHERE etc, it does not ...
-1
votes
2answers
95 views
SQL Authenticated users can't access database
I have just created a user account with SQL authentication with username: test1 and password of password. When I log into this account via the server explorer in Visual studio it is fine. Until I ...
5
votes
1answer
87 views
Any Tricks to Better Identify Disabled SSIS Elements?
Does anyone have any tricks they care to share that will help better identify disabled elements within SSIS packages? Ideally there's some manner to adjust the text color to red or or something along ...
5
votes
1answer
3k views
SQL Server Data Tools for VS 2015 - Anyone using for SSIS development to multiple versions?
According to this link, https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/
the newest version of SQL Server Data Tools - "SSDT for ...
3
votes
1answer
4k views
visual studio 2017 vs sql management studio
I just installed Visual Studio with Data Tools and removed my previously installed Management Studio, due disk constraints, and the transition has not been as easy as I expected.
Most of the time I ...
