Stack Overflow
Stack Overflow

Questions tagged [ssdt-2017]

18 questions
3
votes
0 answers

SSIS Script Component - Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=x' or its dependencies

I tried many steps for this "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies." After i installed Newtonsoft.Json latest version (13.0.1) and excute my…
Logain Theran
  • 51
  • 3
3
votes
1 answer

CREATE ASSEMBLY failed because assembly failed verification. Check if the referenced assemblies are up-to-date and trusted to execute in the database

A database with a CLR dll was migrated from SQL Server 2008R2 to SQL Server 2017. Deployment to this database is automated using DacPac in Azure DevOps. The dll is registered with EXTERNAL_ACCESS. Since the migration to the new server, the…
AXMIM
  • 2,424
  • 1
  • 20
  • 38
2
votes
3 answers

Can SSDT maintain different environment users and permissions in a single project?

We use different service accounts for the different deployment environments, so Dev has Account_A and Prod has Account_B, and any test app using Account_A will not have access to Prod. Or, as another example, Account_A can have read/write…
thomasjbarrett
  • 155
  • 1
  • 1
  • 9
2
votes
1 answer

Is it Possible to export the Analysis Services DB from SSMS into Visual Studio as we can do in Azure Analysis Services

I have created a cube on SSAS in Visual Studio 2017 (SSDT) and deployed on SQL Server Analysis server. I can see the deployed the Analysis Server DB on Prod in SSMS. Over a period of change, I created multiple version of that DB and I can't find the…
Ashish
  • 23
  • 5
2
votes
1 answer

Can't deploy DacPac on Azure DevOps CD

I am building DacPac file from a database project using Visual Studio. Also, in the Debug Drop tab in Advanced Build Settings, I enabled the following options: Do not drop credentials Do not drop database roles Do not drop database scoped…
Adham Enaya
  • 780
  • 1
  • 11
  • 29
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
1 answer

SSDT: Unresolved reference to object

I have an existing SQL Server 2014 database and I want to add it to source control (SSDT in Visual Studio 2017). I have a database project with lot's of views and stored procedures. MyDatabase is current database. Every view and stored procedure is…
Alex Sham
  • 489
  • 7
  • 14
0
votes
1 answer

Using multiple SSDT projects per database? Or have any other ways of dealing with a large database in SSDT?

If one has a big database, it will be very slow to build. Especially if one has a lot of stored procedures and unit tests. One option would be to have two SQL projects that are responsible for different aspects of the database. Then each build…
Diego
  • 1
0
votes
0 answers

Should I migrate SSIS packages from version 2015 to 2017?

I have recently made a switch from SSDT2015 to SSDT 2017. Should I upgrade my SSIS packages to work in my SSDT2017 or no upgrade is required?
cali556
  • 1
  • 1
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
0 answers

SSIS Can run from Visual Studio but cannot run when deployed to SQL Integration Catalog and Run Via SQL Agent

I have issue with SQL Agent when i run it from Visual Studio SSDT its run smoothly No data error and rum based on flow but when i deployed it to SQL Integration Service Catalog and run via SQL Agent the job successfully done, but no data or query…
kucluk
  • 540
  • 2
  • 9
  • 29
0
votes
0 answers

How to add Delete DDL statement through variable in SSDT

I want to delete partitions for specific date via delete DDL statements using variables in SSDT. Currently getting error as "Invalid input" I tried with direct input option also, but it doesn't work. Below code works fine when static date is passed…
Amruta
  • 701
  • 4
  • 15
  • 38
0
votes
1 answer

CDATA SFTP Connecter no file transfer

at work we are trying to migrate some ssis packages from using ftp to sftp for file transfer. We bought the cdata connectors for ssis but all of them seem to be centered about data transfer or connecting to a file on the sftp server as the data…
Kalyn
  • 55
  • 5
0
votes
1 answer

How to exclude user related object from DacPac file

I am creating SSDT project using visual studio, I want to remove the users-related object from the dacpac file before deploying it. I tried to exclude objects from the 'Advanced Deployment Settings' but as you can see on the following screenshot,…
Adham Enaya
  • 780
  • 1
  • 11
  • 29
0
votes
1 answer

Where to Put DLLs to be Used by VS 2017 SSDT

I have an SSRS project that I created using VS 2015 SSDT. It has a reference to barcodelib.dll that's used to create a barcode on the report. The problem is that I got a new PC, and it uses VS 2017 SSDT. Now every time I run it, I get the…
J.Cart
  • 519
  • 1
  • 8
  • 19
1
2