Questions tagged [visual-studio-2015]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
20 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 ...
2
votes
1answer
207 views

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under ...
0
votes
1answer
66 views

Use table in database like in excel [closed]

I'm writing a program for my client in C# Winform. And the client gave this excel sheet. Process I have a table that used to calculate BULK amount of alcohol by "DIP" and "SLIDE". In excel I need ...
0
votes
1answer
112 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
147 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
131 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 ...
2
votes
1answer
3k 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
477 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
1k 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 ...
8
votes
1answer
798 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
2k 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
66 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
313 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
1k 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 ...
2
votes
1answer
125 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
936 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 ...
3
votes
2answers
258 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
252 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
115 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
107 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
74 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
572 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
977 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
249 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 ...
3
votes
1answer
4k 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
501 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
324 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
196 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
486 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 ...