sql-server-data-tools Questions
3
Solved
I have downloaded and installed Visual Studio 2022. Then after click on modify
Now, I want to create SSIS package, for this I have started VS22 and in "manage extensions" when I t...
Packing asked 15/2, 2022 at 12:52
7
Solved
I'm comparing a database in a local SQL Server 2014 instance against an SSDT database project.
I have done previous comparisons and they have worked fine.
At times I also change the project datab...
Bugeye asked 4/9, 2014 at 8:48
3
I noticed that our SSDT projects were building much slower via TFS build definitions than via VS 2013 on my local dev box.
On the build server itself, I can build our largest SSDT project via VS 2...
Tearful asked 12/8, 2016 at 16:50
2
Hi there I am having an same issue in opening a tabular project file in Visual Studio. With the.smproj file I am getting an incompatible error stating that the application is not installed.
The e...
Hanrahan asked 20/5, 2020 at 23:14
4
Solved
Unable to build .Net .sqlproj using "dotnet" command line tool. Here's the error:
dotnet\sdk\3.1.300\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found
...
Iatric asked 30/5, 2020 at 18:53
5
Solved
Disclaimer: There is a similar question on SO that appears to be referring to an older version of SSDT. The selected answer references settings files that are not in my project. I believe I have th...
Archaism asked 12/7, 2013 at 16:58
3
Solved
When I try to preview report in Visual Studio 2012 Designer I am getting an error:
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
An error occ...
Letitialetizia asked 9/5, 2014 at 9:2
3
Solved
I am performing SQL Server schema comparison using Visual Studio 2017. I am pressing on "Generate script" button of Schema Compare utility and see the message
"Update scripts generated successf...
Okwu asked 21/6, 2018 at 23:32
8
Solved
I'm having a very peculiar issue with SQL Server Data Tools 2012. Whenever I attempt to launch the report previewer, I get the following exception:
There was no endpoint listening at net.pipe://...
Huynh asked 7/8, 2014 at 17:20
3
Solved
I have an Execute SQL task which gives returns only one row with one column - a number. I set my result set to single row. Despite that, the task fails. Why ? How do I fix it ?
[Execute SQL Task] ...
Weywadt asked 29/9, 2013 at 6:27
3
Solved
I'm using SSDT to keep 2 databases synchronized.
To do so, I have a database in Server1, a database in Server2 and an Schema in my project.
I always make changes in Server1 database, and apply th...
Cappuccino asked 14/5, 2015 at 16:1
4
Solved
When publishing a dacpac with sqlpackage.exe, it runs Schema Compare first, followed by pre-deployment scripts. This causes a problem when, for instance, you need to drop a table or rename a column...
Rajah asked 1/9, 2015 at 11:41
2
I have a SQL Server database project (VS2017) and in project properties, the SQLCMD Variables tab looks like this:
Question: I can create a SQLCMD variable and set a Default Value and a Local Va...
Michaels asked 27/7, 2018 at 9:51
5
Solved
My solution created with VS2017 Professional contains an SQL Server Database Project that references the master database. When using the Hosted VS2017 agent to build my solution in Visual Studio Te...
Sedgewake asked 14/7, 2017 at 13:4
3
Solved
I get this error from SQLPackage: "An item with the same key has already been added"
What is the meaning? Google won't help me..
"c:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpacka...
Cilla asked 21/3, 2014 at 13:21
4
Solved
I've created a UDF that accesses the [INFORMATION_SCHEMA].[TABLES] view:
CREATE FUNCTION [dbo].[CountTables]
(
@name sysname
)
RETURNS INT
AS
BEGIN
RETURN
(
SELECT COUNT(*) FROM INFORMATION_SC...
Resa asked 7/8, 2013 at 6:21
2
I want to build a .sqlproj inside a linux container. The problem is that building the .sqlproj is dependent on SSDT and so far I can't find SSDT that can be installed as standalone on linux.
Error ...
Benson asked 12/8, 2020 at 20:24
4
Solved
I am using Visual Studio 2013 to manage a .sqlproj file containing our database schema. The schema has been deployed successfully dozens of times.
When attempting to publish to one specific target...
Octahedrite asked 19/2, 2015 at 22:37
4
Solved
Upgrade VS 2019 Professional to latest version 16.10.0. Open an existing SSDT project, double-click on any sql script file in the project, the file can't be opened in a tab window.
If the sql scrip...
Adjustment asked 28/5, 2021 at 20:39
4
I deployed ssis package on sql server 2012. Thereafter scheduled a sql job to run this ssis package weekly.
When I started a job for the first time, it failed with following error.
The job faile...
Rapp asked 17/4, 2015 at 8:54
4
I am using SSDT in Visual Studio 2013.
I have created some pre and post publish scripts for the development server. The pre-deployment scripts empty data from tables and re-set all the auto identi...
Dusen asked 3/2, 2016 at 10:11
6
Solved
I have a database project in SSDT and when I import a view that references objects in a different database, I get error SQL71561, with a description along these lines:
Error 4 SQL71561: View: [s...
Whoredom asked 28/8, 2012 at 14:21
4
Solved
I found and read this question but I didn't found my answer SSDT hooking alternative in x64 systems
I want to protect my application against termination by other programs. In the 32Bit version of w...
Kmeson asked 12/12, 2013 at 19:20
1
When I attempt to deploy DACPACs via SqlPackage.exe,
I encounter the error below :
An unexpected failure occurred: Object reference not set to an instance of an object..
Unhandled Exception: Syste...
Barham asked 11/7, 2016 at 14:7
3
We have started using SSDT to manage our script deployments. Initially we used Schema Compare and unchecked the parts we did not want to deploy. We now have a need to use Pre and Post-Deploy script...
Villarreal asked 20/7, 2018 at 19:37
© 2022 - 2024 — McMap. All rights reserved.