sql-server-data-tools Questions
2
Solved
I have a report that is has a multiple value parameter. It has available values (1, 2, 3, 4, 5, and blank). The blank value isn't NULL it is just an empty cell.
For testing purposes, there should...
Booking asked 20/10, 2015 at 16:32
2
Solved
When I try to build my SSDT project with MSBUILD, I get the following error
error MSB4019: The imported project "C:\Program Files
(x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data....
Claresta asked 20/3, 2017 at 12:6
1
I am getting the following error with my database project in VS2012. The problem started when I added a custom type in my Database project in VS2012.
CREATE TYPE [dbo].[DestAttractions] AS TABLE(
...
Aeolian asked 23/2, 2015 at 16:28
3
Solved
The team of developers I work with are using SQL Data Projects for a large piece of work we have to do against an existing database. We are a few weeks in and there have been a few gotchas, but the...
Banquet asked 11/9, 2015 at 12:47
2
I have a PostDeployment script in a SQL project which runs a number of other scripts in the project when published:
:r .\Scripts\Script1.sql
:r .\Scripts\Script2.sql
:r .\Scripts\Script3.sql
:r...
Foreyard asked 17/2, 2015 at 12:45
1
Solved
I use VS2015 with SQL Server Data Tools; I have some Reporting Services (RDL) reports.
I want to deploy them to a Reporting Server with SQL Server 2014 installed.
In my report project I set the T...
Faint asked 14/6, 2016 at 15:26
3
Solved
Is there any way of preventing users being dropped when publishing a DACPAC using SqlPackage.exe, other than changing the setting below, which prevents all objects from being dropped if they're not...
Celandine asked 1/7, 2013 at 11:1
2
Solved
Assuming we have a database project called MyDatabase then a file called MyDatabase.jfm appears in the root of the project directory.
It is exclusively locked while the project is open in Visual ...
Radford asked 8/6, 2016 at 13:52
2
Solved
I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has driven me nuts because I don't know how to separate the statements:
@[Use...
Garlen asked 12/6, 2015 at 16:41
1
Solved
We are deploying to MS SQL Server localdb for integration testing.
We build a Database Project and the resulting dacpac file is copied in order to be used by the IntegrationTests project. So far w...
Deportation asked 12/4, 2017 at 9:23
1
Solved
According to this answer, SQL Server Data Tools uses a private LocalDB instance ProjectsV13, which you're not supposed to use for your own applications. Instead, you should use MSSQLLocalDB or your...
Tagliatelle asked 4/4, 2017 at 15:9
0
I am failing to deploy Database project using command line parameters with msbuild. I would like to:
use publish xml profile
define connection string as command line parameter
but this seems to...
Guinn asked 11/3, 2017 at 23:36
2
Solved
I am working on a DWH application. The server I was granted access to only has SSIS installed with no database engine. I am getting errors like:
The EXECUTE permission was denied on the object '...
Lueck asked 24/2, 2017 at 11:41
2
Solved
NOTE: This appears to be a problem with the compiler that's used with SSDT projects, it's apparently fixed in the 2017 RC. My problem is similar to one described here.
I've got some code which ref...
Palatinate asked 4/2, 2017 at 7:44
2
I am trying to install SQL Server Data Tools - Business Intelligence for Visual Studio 2012 on my currently installed SQL server.
I get the following error during installation : same architecture...
Newborn asked 15/2, 2016 at 9:8
1
Solved
I created a SSIS Package in Visual Studio SSDT 2012, using Package Deployment model. Is there any way to get access to the package's file name as a readonly variable or property from within the pac...
Seumas asked 13/3, 2016 at 17:18
2
Solved
We are using SSDT tools with Visual Studio 2015 and Target Platform set to SQL Server 2008. We are stuck with this function which is throwing an error and need assistance on what we can do to fix i...
Homothallic asked 9/12, 2016 at 8:2
1
I am working on an Integration Services project.
One of the data sources I use calls for a package to be installed from NuGet.
I tried to go to "Tools > NuGet Package Manager",
but it ...
Cellophane asked 5/12, 2016 at 15:30
3
Solved
I have an issue with compilation of SSDT SQL Server Database Project by using Visual Studio 2015. I want to use C# 6 features inside my database project, but it seems like it is unsupported.
For ex...
Edacity asked 8/10, 2015 at 9:24
0
I am new to SSDT and I'm following the Analysis Services Tutorial called Multidimensional Modeling (Adventure Works Tutorial). And I'm currently on Lesson 3, on the step Modifying the Customer Dime...
Magocsi asked 12/10, 2016 at 0:13
3
Solved
So, I've got a project in SSDT (SQL Server Data Tools) in Visual Studio 2012. When I build this project, there are no errors - it builds fine (not even a warning or a message).
However, if I try a...
Calabria asked 31/1, 2013 at 19:21
3
Solved
I am trying to filter some row of a table with ssdt (left click on table, view data, sort and filter)
Here I simply need to add IS NULL as a condition to an nvarchar field.
But as soon as I apply ...
Rein asked 27/8, 2015 at 15:32
2
Solved
I have a Visual Studio 2015 DB project for SQL Server DB, where I can do a schema compare/data compare and check in the project into Git manually. I wanted to automate this complete process of doin...
Overact asked 19/9, 2016 at 14:46
2
Solved
I am testing SSIS package that I upgraded from VS2005 project to VS2013 (package deployment model) project. This is very simple package which just processes files one by one from specific location ...
Taciturnity asked 17/2, 2016 at 22:43
1
Solved
We have a build step to build a solution with about 70 projects using the Visual Studio (sln) as the runner type. We are able to successfully build other projects that are not supported by MSBuild,...
Sentimental asked 7/9, 2016 at 13:50
© 2022 - 2024 — McMap. All rights reserved.