Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [visual-studio-2015]

The tag has no usage guidance.

0
votes
0answers
18 views

Differences between Visual Studio Data Source vs External Database outside of Visual Studio

I've worked with many databases outside of visual studio. When I find myself working in Visual Studio having to work with either Oracle Express, SQLite or MS SQL Express - I have never used the ...
0
votes
1answer
43 views

What do I need to develop an integration service to extract data from an Oracle DB to a SQL Server DB using Visual Studio 2015? [closed]

I have to develop an ETL to extract some data from an Oracle DB 11g to a SQL Server 2017 DB. I am pretty new at all this technology so I would like some advices. The strongest problem so far is to ...
0
votes
1answer
62 views

How to find the erroneous code failing the SSDT publish?

Every time something fails the publish, assuming it passes the preview generation, the error line and executed script sample are completely useless at helping me trace the source of the error, since ...
3
votes
0answers
123 views

User defined stored procedure - where's the execution plan?

SQL Server 2016, Enterprise Edition in Windows Is there anyway to display the execution plan of a stored procedure created in C# with Visual Studio Data Tools? This is a question that someone with ...
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: ...
4
votes
1answer
303 views

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL ...
5
votes
1answer
864 views

Visual Studio, GIT, and SQL Scripts [closed]

I am trying to figure out a way to have all of our random SQL scripts that we write under source control. I am already using SSDT for the database project. This is not for these sort of scripts. It is ...
5
votes
1answer
281 views

Option to uncheck all or invert selection in SSDT?

In SQL Server Data Tools (SSDT) after compared the schema, I want to update few changes of mine only (as red-circled in the screenshot). But there are many other changes are listed in the window, I ...
5
votes
1answer
957 views

Failed to start TSQL debugger

I want to debug in TSQL.When I start the debug the following message box popup. In SSMS v17.2 Then I see this message: In Microsoft Visual Studio 2015 Server Explorer same Error: Then I see this ...
2
votes
0answers
64 views

Visual studio 2015 closed when re-run SSIS pack

I recently installed visual studio 2015 and there is a really simple action that I can not make, When I rerun (Ctr+Shift+F5) SSIS package (re-run, not run), it causes visual studio to throw this error:...
4
votes
1answer
269 views

What do most people use to work with SSIS packages since VS2015 UI is buggy?

I don't think I can post bugs on Microsoft connect. I'm trying to use SSDT on VS community edition. And the UI is terribly buggy. Here are some screenshots: The Enumerator properties manager is just ...
2
votes
1answer
761 views

Send emails based on query results

I have a request to send emails the first of every month for each department that hasn't submitted their hours. I have a query that generates a list of email addresses, the email subject, and the ...
1
vote
1answer
100 views

Query not working is it issue with VS 2015 Community ASP.Net Core WebAPI or SQL Server 2016

I am experiencing an issue, which is beyond my understanding in trying to figure out, I am not sure if it is some glitch with Visual Studio, or something wrong with my SQL Server DB. I originally ...
-3
votes
1answer
764 views

Creating MDF tables using Visual Studio 2015

I'm using Visual Studio 2015. In Explore Server, I create a new DB.mdf file. When I right click on "Tables" I don't have the option to create a new table. Do I need to install something in order to ...
2
votes
2answers
188 views

sqlpackage.exe SELECT statement causing massive reads

We are using sqlpackage.exe to deploy scripts onto a SQL Server 2016 SP1 instance. Running sqlpackage.exe executes this SELECT SELECT * FROM ( SELECT SCHEMA_NAME([o].[schema_id]) AS [SchemaName], [...
1
vote
0answers
176 views

How to explicitly convert to fixed-length alphanumeric datatype in 4D

I'm building an ETL process in SSIS that extracts data from a 4D data source using the manufacturer's own ODBC provider (4D v16 ODBC Driver). When I try to extract any type of "string" column, it ...
-1
votes
1answer
1k views

Can't connect to LocalDB from Visual Studio 2015

When I try to connect to the database, to which I was previously able to connect, I get the following error: I tried to solve this by looking up other stackoverflow questions and online resources, ...
-1
votes
1answer
92 views

New to SQL: trouble with being refused access to local Adventureworks installed server

Evening, I recently installed Visual Studio 2015, SSDT, SSMS, SQLExpress2014 and LocalDB. I'm attempting to do this tutorial: https://technet.microsoft.com/en-us/library/c1e68a88-0f82-415d-becc-...
0
votes
1answer
86 views

SSRS trying to deploy to wrong server

I added a report project to my existing solution in VS2015, built some reports and now I am trying to deploy the project to a report server. I have gotten the URL from the config manager ( http://...
0
votes
2answers
68 views

SSIS Promote Package - Move Some Stored Procedures

I am trying to create an SSIS Package in Visual Studio that I can use when front end deployments are made. Quick rundown - copy prod DB to temp backup move new/updated stored procedures from prod ...
2
votes
0answers
488 views

SSIS parameter crashes Visual Studio

I am experiencing a weird behavior with SSIS parameters. At the start of the SSIS package, I have a script task. In the Script Task Editor I select a package parameter as a read only variable. When ...
1
vote
1answer
791 views

Error when only deploying a dimension on SSDT

I'm trying to follow a tutorial on SQL Server Analysis Services (SSAS) but I'm having trouble on deployment. Summarized, what I'm doing is: Open SQL Server Data Tools (SSDT) Creating a new ...
2
votes
1answer
194 views

Programmatically get parameters required by DACPAC

Is there a way to find out what parameters a DACPAC requires? I know they are listed in an error message if you try to publish without parameters, but that takes too long - 10-15 seconds. Also, a ...
2
votes
1answer
3k views

“CREATE FILE encountered operating system error 32” when attempting to attach database

I am having trouble connecting to a database I created in SSMS. Keep in mind this is my first time working with databases. All I've done in this database is create some tables and add a few records. ...
0
votes
1answer
446 views

Visual Studio 2013 and up - Database Project Schema Compare File

Is there any reason to save the schema compare file once you are done comparing, creating scripts or just simply updating?
1
vote
2answers
178 views

SSDT table column order

I realized that the behaviour of SQLPACKAGE.EXE changes depending on what changes have been made to a table schema: Adding a new column at the end of the table: "Table is changed" Removing a column ...
0
votes
1answer
160 views

Howto remind and restore recovery mode during SSDT deployment?

Due to deployment of a SSDT database project I would like to be able to switch the target database's recovery mode from FULL to BULK LOGGED and back after the deployment finished in order to do any ...
0
votes
1answer
369 views

SSDT Publish Window: What does checkbox ENABLE mean?

In the Visual Studio 2015 SSDT "Advanced Publish Settings" Window, Tab General, "Advanced Deployment Options" there are several checkboxes in the column "ENABLED" we can check or uncheck. Most of the ...