Stack Overflow
Stack Overflow

Questions tagged [ssdt-2019]

26 questions
0
votes
0 answers

Identify which Visual Studio project file contains a named database object

I need to develop a C# function which, given a named SQL Server database object e.g. [MySchema].[MyStoredProcedure], will identify which file in a Visual Studio database project contains the definition of that object.…
Hugh Jones
  • 2,706
  • 19
  • 30
0
votes
1 answer

Regenerate SSAS multidimentional partitions files from the database

I have an ssas cube and I want to create the solution with ssdt on visual studio. I need to generate the .partations file of the cube. When I do New Project -> Import from server (multidimentional and data mining) The project is created but the…
SniperPro
  • 75
  • 1
  • 10
0
votes
3 answers

Why SSDT installation process stop with the error 0x80070001?

[3884:3870][2022-02-19T01:38:46]e000: Error 0x80070001: Process returned error: 0x1 [3884:3870][2022-02-19T01:38:46]e000: Error 0x80070001: Failed to execute EXE package. [346C:3470][2022-02-19T01:38:46]e000: Error 0x80070001: Failed to configure…
Isuru Prabhath
  • 11
  • 2
  • 3
0
votes
0 answers

SSIS/SSDT Testing Connectivity even when Work Offline is checked

I have a SSIS solution containing two projects. Both projects use parameterized project level connections, with the same connection properties. I have checked Work Offline. Project 1 opens just fine, with the connections correctly showing as…
Wes H
  • 4,186
  • 2
  • 13
  • 24
0
votes
1 answer

How do I drop system versioned tables in a SQL Server database project

We're using a .NET SQL Server database project to define our database, and it's not deleting tables from the server even though we have deleted them from the database project. There is an option in the publish profile to drop objects that are in the…
David Kethel
  • 2,440
  • 9
  • 29
  • 49
0
votes
0 answers

Can SSDT 2019 packages deployed on SQL Server 2014?

Can SSDT 2019 packages deployed on SQL Server 2014? I don't have to install SQL Server 2019 for SSDT 2019 and should be able to deploy package to 2014, correct?
user1810575
  • 823
  • 3
  • 24
  • 45
0
votes
1 answer

Cannot apply equality in SQL Data Tools scripts "Operator '==' cannot be applied to operands of type 'bool'" (FIX)

Cannot apply equality in SQL Data Tools scripts. Purpose: Establish a variable to use as a graceful exit when nothing needs to be done ERRORS "Operator '==' cannot be applied to operands of type 'bool'" Only assignment, call, increment, decrment,…
Jamie
  • 437
  • 4
  • 15
0
votes
1 answer

SSRS Only Totaling Middle Rows in Sum of Amounts by Customer

I'm new to SSRS/SSDT (2019) and I assume I'm missing something simple? I have a simple table that looks something like…
Noah-Smith
  • 3
  • 1
0
votes
1 answer

SSRS Report runs slower in Preview Mode/Report Viewer

I am using Visual Studio 2019 and using Microsoft Reporting Services Projects Extension v2.6.7. The problem i am facing is i have a report that process about 60k records, the report is complex and has Groups, repeat headers, dataset filters and also…
Vinayak
  • 55
  • 11
0
votes
1 answer

Integration of tSQLt + SSDT into Jenkins

I am using SQL Server 2017 and Visual Studio 2019 Community edition. I have created my first SSDT project and configured it in Jenkins and I am facing issues while deploying it before running my tSQLt test cases. Please refer to the link which I…
user13875967
  • 21
  • 6
0
votes
1 answer

Azure Devops - SSDT DB build error - writing model.xml

I get the following build error for my SSDT project in Azure DevOps: System.IO.DirectoryNotFoundException: Could not find a part of the path 'd:\a\1\s\SSDTPROJECTNAME\SSDTPROJECTNAMEobj\Release\Model.xml'. Earlier in the build it attempts to write…
Joe Eng
  • 1,072
  • 2
  • 15
  • 30
1
2