Questions tagged [ssdt]

SQL Server Data Tools is a free component of the SQL Server platform and is available for all SQL Server users. It provides a modern database development experience for SQL Server versions 2005 and up as well as SQL Azure.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

Why is my SSIS package not getting updated?

I have a Integration Services project within SSDT that has multiple packages. When I right click a single package and choose deploy, SSDT says the operation completed successfully. However, when I ...
9
votes
1answer
470 views

Is there a way to easily validate that a SQL Script is compatible with a specific SQL Server version?

I am currently working on a project that needs to operate in different SQL environments. Most of my developers have SQL Server 2017. The application runs in SQL Azure, and the client has recently ...
2
votes
2answers
83 views

How to Exclude Foreign Keys during Publish action in sqlpackage

I am trying to publish a .dacpac extract to a target database, I want to exclude just the foreign key constraints in all the tables. After going through the ExcludeObjectTypes options I do not find a ...
2
votes
1answer
85 views

DACPAC Deployment Rebuilding All Indexes

I'm in process of deploying a DACPAC provided by our ISV. The DACPAC is rebuilding every index in the database. We're testing in a Lab now, however, this will create a significant impact to our ...
0
votes
0answers
22 views

Is there an underling difference between TIMESTAMP and ROWVERSION when creating columns with each?

I'm having problems with SSDT detecting a change to a "TIMESTAMP" column where both the target column and model.xml column definition are of type "TIMESTAMP". When this happens, the following alter ...
2
votes
1answer
72 views

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under ...
0
votes
0answers
28 views

Cannot create or use an SSIS package template in SSDT 2017

ENV: Using VS 2017 Professional/SSDT 2017 on Win10 pro. Our company does NOT allow developers to have Admin Rights on their laptops so the ONLY way to create and use a template is to save it in the ...
0
votes
0answers
27 views

Data Loss issue while migrating data from Source(Oracle) to Data Warehouse Staging Database(SQL Server)

Project Overview Loading data from Oracle Database to Datawarehouse Staging Database(SQL Server). Using ETL process we are loading data from Oracle to SQL Server. Staging Database in SQL server is an ...
0
votes
0answers
19 views

SSIS Package runs fine with a few rows but not with a bunch

I have an SSIS package that runs a Script task as its final step; it calls an API and waits for a response. The API writes files to disk, so it's easy to see if it's working; if files are getting ...
1
vote
1answer
42 views

SSDT Publish failing with an error without even running any statements

My publish attempts are failing with this error Msg 205, Level 16, State 1, Line 7572 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in ...
2
votes
0answers
57 views

SSDT Schema compare to compare only specific objects

Is it possible to use schema compare in SSDT to compare only specific objects? Not object types, specific objects like 3 tables and 2 stored procedures instead of all tables and all stored procedures?
2
votes
1answer
98 views

SqlPackage.exe unnecessarily drops and recreates indexed view with schemabinding

Currently SqlPackage.exe used in conjunction with BitBucket for the deployment of the database schema changes. Recently a pretty large indexed view has been created based on 3 source tables, which ...
0
votes
0answers
79 views

SSIS/SSDT packages no longer showing in Visual Studio after deploying

So earlier today I had deployed my project including SSIS packages to my SQL Server. They successfully showed up ( but were giving me a duplicate key error). So I decided to save the project and end ...
0
votes
0answers
32 views

SSDT solution missing packages after deploying project to SQL Server [duplicate]

Earlier today I deployed my project and SSIS packages to my SQL Server, the succesfully showed up in the SSIDB catalog. I encountered an error about a key that I had intended to fix when I got home to ...
0
votes
1answer
11 views

Does MS provide a way to query a SSDT project

Is there a way to query a SSDT project to get a list of tables or foreign keys? Similar to what you can do with the actual database?
1
vote
1answer
66 views

Ms VS2017 with SSDT has the 'User with Password' template but thinks it's wrong

In my database project when I choose the 'User with Password' template in the Add New Item dialog, code is generated, kind of CREATE USER [u2] WITH PASSWORD = 'jbniq_ushfbwc=l5nAxu8aapmsFT7_&...
2
votes
1answer
277 views

Publishing database changes with SSDT that include adding columns to existing table to the target database through Project

Publishing database changes with SSDT that include adding columns to the existing table in the target database(which was previously created through SSDT).Instead of creating a new SSDT database. ...
7
votes
1answer
288 views

Storing CREATE EXTERNAL DATA SOURCE in a SSDT project without exposing the DATABASE SCOPED CREDENTIAL or MASTER KEY secret;

I have a SSDT project that deploys to Azure SQL DB. Recently I added an external table. This required an external data source as follows: CREATE EXTERNAL DATA SOURCE [data_warehouse] WITH ( ...
0
votes
0answers
57 views

Alternate to merge statements for managing static data in SSDT projects [duplicate]

I have a database in which some of the tables are relatively static. To keep the data in sync between versions of the database I use merge statements generated by sp_generate_merge in post deploy ...
3
votes
1answer
249 views

What does @RC mean in SSDT SQL Server Unit Testing?

In Sql Server Unit Testing, SSDT, what does @RC stand for? Does it mean Row Count, or Row Column? Team wants to understand, we have been using it for long time, good tool which works, just curious.
0
votes
1answer
2k views

Install SSDT for VS 2017 - Missing Integration Services

I have downloaded and installed SSDT from Microsoft docs. The install was successful and I now have SSDT for VS 2017 installed - version 15.8.9 (as per screenshot) However, I cannot create an SSIS ...
1
vote
1answer
274 views

Visual Studio SSDT Ignore Query Store Options in Publish Profile

Is there any way in Visual Studio SSDT Publish Profile, to Totally Ignore Query Store Options Completely? It keeps asking us to Rerun publish code below. I go to Database advanced settings, and turn ...
3
votes
1answer
124 views

SQL Visual Studio Find and Replace in Publish Profile

We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References. We need Project references, since ...
4
votes
1answer
336 views

Reinitialize Table Values in SQL SSDT Unit Testing

I am creating SQL Server Unit Tests. We are testing various stored procedures. In Unit testing principles, it is good practice to setup a small database table, populate values, and tear down (...
2
votes
1answer
181 views

Make SQL Server SSDT Database Project Reference Different in Publish Profile

In a SSDT Database project, I know how to publish the Self-Database to different locations. I can change eg, the Customer database name in the Publish profile. Example In: Dev Environment: will ...
1
vote
0answers
250 views

View with OPENQUERY won't build in SSDT project

I have an existing database that I'm trying to set up as a database project. I'm not able to get the following statement to build: CREATE view [dbo].[VW_SOMEVIEW] as SELECT * FROM OPENQUERY ([...
1
vote
1answer
694 views

How to read data from multiple Excel files with SQL Server Integration Services(New Senario)

Hope you're doing well. I have a scenario here. As you can see I have a table with two main columns : What I need is to read each "FilePath" which is "Active" right now and then read the Excel files ...
0
votes
1answer
602 views

How do I compare Schemas for Multiple Databases to a True Copy?

We have a database for each customer, over 700 databases. All the schemas are supposed to be exact same. We have Source Control database, and want to schema compare to the 700. Sometimes schema in ...
0
votes
1answer
379 views

SSDT - Deprecated table trigger preventing publish

There is a table trigger that was removed in the past that is blocking SSDT publish preview: This deployment may encounter errors during execution because changes to [table] are blocked by [trigger]'...
5
votes
2answers
2k views

SSDT Drop and Recreate Tables when nothing has changed

We have a Visual Studio Database Project consisting of about 129 Tables. It is the primary database for our Internal Web Based CRM/Call Centre product, which is still under active development. We ...
0
votes
1answer
92 views

How to find the erroneous code failing the SSDT publish?

Every time something fails the publish, assuming it passes the preview generation, the error line and executed script sample are completely useless at helping me trace the source of the error, since ...
0
votes
1answer
246 views

SQL SSDT Database Projects: Source Control Lookup Data

Does SQL Server SSDT Visual Studio 2017 Database Projects support Source control data for lookup tables, or do we still have to utilize messy Post-Deployment Merge Scripts for multiple tables? ...
1
vote
2answers
6k views

How to rollback a SQL Server transaction and use output param?

I am trying to set an output param in a stored procedure, but I think that when I rollback the transaction I think I'm also rolling back the assignment to @out. Is that correct? If so, how can I ...
7
votes
1answer
2k views

SQL Server - Adding non-nullable column to existing table - SSDT Publishing

Due to business logic, we need a new column in a table that is critical to ensure is always populated. Therefore it should be added to the table as NOT NULL. Unlike previous questions that explain how ...
1
vote
1answer
91 views

SSMS 10.5 alongside 17.7

To set the scene, I maintain 4 local SQL Server 2008 R2 instances. At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure. I am currently using SSMS ...
2
votes
0answers
210 views

SQL Server - How to track down error thrown in SSDT publish preview?

Without flailing through a file search, how does one track down the code that caused an error during SSDT publish preview? Normally any errors come later such that the statement can be traced in the ...
1
vote
2answers
123 views

Dev/Test Environment For Databases With Cross-Database Joins

We have existing databases under source control in SQL Server Database Projects with a number of these databases referencing each other. Getting these into projects and source control was challenging ...
2
votes
1answer
624 views

Dacpac deployment via sqlpackage, “DropObjectsNotInSource=True” is trying to drop .mdf & .ldf

Powershell deployment script: Executing: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe /Action:Publish /SourceFile:********.dacpac /Profile:Release.Publish.xml /...
1
vote
1answer
81 views

SSDT: Requires Visual Studio? Requires connection to SQL Server? (SQL Server 2016)

I need to make some SSIS workflow packages. I see I can do this in SSDT. I have not used SSDT before. It appears that SSDT installs into Visual Studio. OK, I can do that. (I have VS 2015 installed.) ...
1
vote
1answer
318 views

SSIS convert flat file cell to HH:MM:SS

I see similar questions, but most have to do with datetime or fairly different requirements. I have a CSV report that has a time column stored as HH:MM[:SS] (if over 1 day, it adds :00 for seconds... ...
2
votes
1answer
20 views

How is SSDT Data Flow batching handled?

How does SSDT handle batching of Data Flow tasks? I am parsing a CSV that is about 1GB into SQL Server using SSDT. In the Data Flow there is a Flat File source, that goes to an OLE DB destination (a ...
1
vote
0answers
486 views

SQL Server Data Tools 15.5.0 - Script Component Validation Error

When trying to use the script component in an SSIS dataflow I am getting a validation error meaning the script and my package will not work: Severity Code Description Project File Line ...
2
votes
0answers
580 views

How Can I Ignore Partition Schemes in my VS SSDT Database Project

We use SSDT in VS 2015 to manage our database project code. Recently, we've been implementing partitioning on some tables in databases that are managed with SSDT. I need to include the partition ...
1
vote
0answers
85 views

Builds and deployments to 300+ databases utilizing SSDT/VSTS

I have built a database project within SSDT for Visual Studio 2017. I have also created Publish profiles that succesfully deploy to our dev, QA, staging, and production databases with no issue, ...
3
votes
1answer
554 views

SSIS Failed foreign key constraint

I'm loading 2 csv files into 2 tables in SQL Server Data Tools using SSIS, and the 2nd one is connected to the 1st via a foreign key constraint. The problem is that a row of the 2nd table has a key ...
5
votes
1answer
502 views

Option to uncheck all or invert selection in SSDT?

In SQL Server Data Tools (SSDT) after compared the schema, I want to update few changes of mine only (as red-circled in the screenshot). But there are many other changes are listed in the window, I ...
1
vote
1answer
462 views

SSDT Publish fails because 'System.DirectoryServices' failed verification

Imported an existing database (SQL2012) to an SSDT project in VS2017 and when trying to deploy it to my local instance (SQL2016) I get the error message: CREATE ASSEMBLY for assembly 'System....
0
votes
1answer
346 views

How to avoid dropping schemas when publishing DB in SSDT Database project

When publishing a database from SSDT, there are several options to "do not drop" an object if it is not in the SSDT project. However, it seems that there is no option to avoid dropping schemas. Do ...
4
votes
1answer
296 views

What do most people use to work with SSIS packages since VS2015 UI is buggy?

I don't think I can post bugs on Microsoft connect. I'm trying to use SSDT on VS community edition. And the UI is terribly buggy. Here are some screenshots: The Enumerator properties manager is just ...
0
votes
2answers
1k views

Red Gate SQL Prompt in Visual Studio not working?

I have tried out SSDT Database project in Visual Studio, and with the SQL Prompt solution from Red Gate. It seems that the intellisense only works for SQL keywords like SELECT, WHERE etc, it does not ...