Stack Overflow
Stack Overflow

Questions tagged [ssdt-2019]

26 questions
4
votes
0 answers

Integration Services 2019 - Execute Process Task - WindowStyle ignored

I recently migrated projects developed in Sql Server BIDS 2008 to Visual Studio Professional 2019 with SSIS extension. After the upgrade all the packages are now up and running, but when I run them in debug mode, all Exectue Process tasks with…
AdamL
  • 12,421
  • 5
  • 50
  • 74
3
votes
3 answers

How can I install SSDT for use in an enterprise without a license (i.e. for free $$$)?

I want to create a SQL Database project and manage my database as code (e.g. DevOps), but I am not sure what tools I can use for free within an enterprise. How do I install and use SSDT without requiring paid licensing and violating any EULAs, such…
successhawk
  • 3,071
  • 3
  • 28
  • 44
3
votes
0 answers

SSDT always redeploys tables with system_versioning but doesn't update the table

I have a couple of system_versioned tables and deploy the project via SSDT to an Azure SQL Managed Instance. For many of these system_versioned tables SSDT always recreates the publish code or shows these tables as differing in schema compare (see…
tim
  • 86
  • 7
2
votes
3 answers

Unable to compile SSDT Database Project with a view that has fully qualified name of table in view definition

We have a SQL 2019 database where all table names are fully qualified in views starting with the database name. We do NOT have the option of avoiding the fully qualified reference as the view definition is auto-generated (otherwise I would simply…
Geekn
  • 2,650
  • 5
  • 40
  • 80
2
votes
0 answers

Suppression of reference errors in VS database project not working

I would like to suppress all SQL71561 errors in my database project. There are a lot of views that are built in this database that reference tables from another. However, it is not feasible for me to import that other database into a DB project, nor…
Tyler
  • 103
  • 1
  • 9
1
vote
0 answers

Show warning on missing column on VSSDT

On Visual Studio 2019 SSDT. Inside a procedure we have: create table a (test1 varchar(50)) create table #b (test2 varchar(50)) select a.nop from a select a.nop from a, #b b where a.test1 = b.test2 The first select gives a warning of columns…
Fernando Aguilar
  • 11
  • 2
1
vote
2 answers

Compile a function in an SSDT PreDeployment Script

I have an unusual situation - first time! I'm trying to write a pre-deployment script for an SSDT Project in Visual Studio, which will prepare a load of data for migration. There's a user-defined table-valued function (TF) in the new version of the…
Adam
  • 1,932
  • 2
  • 32
  • 57
1
vote
1 answer

Microsoft SSIS SQL Server Integration Services Installation Error Visual Studio 2019

I am trying to deploy the SSIS developer toolkit to my Visual Studio 2019 instance. I tried yesterday's download as well as a new download today with the same result. Details are below. I will also look at another Stack post here and see if this…
cmill
  • 849
  • 7
  • 20
1
vote
0 answers

How do I suppress SQL71501 error messages?

I have a Visual Studio database project which I cannot build because of many SQL71501 errors. Error SQL71501: Computed Column: xxxxx contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous…
BrokenBad
  • 95
  • 6
1
vote
0 answers

SSDT Post Deployment & Always Encrypted

Struggling with an issue in SSDT when deploying seed data to a table that has AlwaysEncrypted Enabled. SQL Server 2019 Enterprise Windows Server 2016 Data Center Visual Studio 2019 Community Edition 16.7.2 (current release as of this post) Column…
Nathan Heaivilin
  • 33
  • 3
1
vote
1 answer

SSDT: Unable to connect to master or target server 'DB_NAME'. You must have a user with the same password in master or target server 'DB_NAME'

I am going to automate the database deployment through SSDT-DACPAC by using Visual Studio 2019, DATABASE from where changes will deploy is SQL SERVER 2019, and for deployment medium I am using Azure pipeline and task 'SQL Server database deploy'…
Saad Awan
  • 566
  • 2
  • 9
  • 23
1
vote
2 answers

Create SSIS package with SQL Server 2019/Visual Studio 2019

How do you create an SSIS package with SQL Server 2019/Visual Studio 2019? I don't see any BI options for SSIS, SSRS, or SSAS when creating a new project in Visual Studio. I have the free SQL Server 2019 Developer edition installed. I also have the…
tinafmills
  • 39
  • 1
  • 1
  • 5
0
votes
0 answers

How to connect Excel file within SSDT-Visual Studio (32-bit) on a Windows Server 64-bit?

How could I read an Excel file with SSDT-Visual Studio 2019 under Windows Server 2016 64-bit ? I see there are a lot of blogs describing similar issue but I'm still not able to solve my problem. I would like to read an Excel file within my Visual…
nrdotca
  • 1
0
votes
0 answers

SSDT Unit Testing with Database Variables

I have a database project in Visual Studio 2019 that references another database. I have added a dacpac and use a variable to reference that database. This works great, until it comes to unit tests. I have added a unit test project, but the Unit…
mickeysox
  • 159
  • 2
  • 14
0
votes
0 answers

How to show detailed diagnostic information when publishing dacpac with dacservices object?

How to show detailed diagnostic information when publishing dacpac with dacservices object? SqlPackage.exe has a Diagnostics switch for detailed output of the publish operation. /Diagnostics: /d {True|False} Specifies whether diagnostic…
user5855178
  • 567
  • 1
  • 7
  • 17
1
2