Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
17 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
44 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
51 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
52 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]'...
2
votes
2answers
112 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
30 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 ...
1
vote
1answer
62 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? ...
0
votes
0answers
49 views

SSIS Microsoft.SQLServer.DTSPipelineWrap.dll not found

I'm trying to build a SSIS package from an external application but I'm getting the following error: Internal Error - Build package for XXXX failed Could not load file or assembly 'Microsoft....
1
vote
2answers
752 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 ...
5
votes
1answer
315 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. Updating existing references that insert/update is difficult but doable, but ensuring future code/...
1
vote
1answer
78 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 ...
0
votes
0answers
51 views

Set FILESTREAM DIRECTORY_NAME value via SqlCmd variable in SSDT database project

Following on from a previous question I've run into an issue when using database variable references in my project due to the error: FILESTREAM DIRECTORY_NAME 'FooBar' attempting to be set on ...
2
votes
0answers
69 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 ...
0
votes
0answers
73 views

Suggestion about SSIS deployment environment

I don't know if my question belongs here or is more fitting for ServerFault, I'll start from here because it has to do with Sql Server (especially with Integration Services). I am developing an ...
1
vote
2answers
49 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
242 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
50 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
138 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
17 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 ...
0
votes
0answers
175 views

Integration Services Deployment Problems With VS2017/SSDT 15.5.1

I have an Integration Services Project in Visual Studio 2017 with SSDT 15.5.1 that targets SQL Server 2012 that will not deploy due to out of memory errors despite having plenty of available memory. ...
1
vote
0answers
248 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 ...
1
vote
0answers
205 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 ...
0
votes
0answers
132 views

MSBuild connection string error?

I'm having a hard time getting MSBuild to publish the project to my database: <?xml version="1.0" encoding="utf-8"?> <Project ToolsVersion="14.0" xmlns="http://schemas.microsoft.com/...
1
vote
0answers
69 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, ...
2
votes
1answer
188 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 ...
2
votes
0answers
149 views

Option to uncheck all or invert selection in SSDT? [closed]

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
285 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
162 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
206 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
656 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 ...
3
votes
2answers
633 views

What is SSIS in relation to SQL Server?

I'm finding acronomes such as 'SSIS', 'SSDT', etc etc a little confusing as to how they related to SQL Server. It seems to me that SQL Server implements the T-SQL language, and that a package such as '...
5
votes
1answer
2k views

SQL Server Data Tools for VS 2015 - Anyone using for SSIS development to multiple versions?

According to this link, https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/ the newest version of SQL Server Data Tools - "SSDT for ...
1
vote
1answer
126 views

page_verify none by default

I am reviewing freshly generated scripts out of SSDT publish tools. These projects were built from a default template, as were the publication profiles. They set page_verify none for the database. ...
1
vote
2answers
455 views

SSDT publish multiple referenced database projects to new instance

I am going through the process of importing our existing SQL Server databases into SQL Server Data Tools in Visual Studio 2015 with the aim of putting them under version control. All the database ...
0
votes
1answer
727 views

Data Migration and altering tables in one SSDT deployment script

I'm using SSDT and MS SQL Server 2012. And I need to handle next cases in one deployment script: --1 CREATE TABLE Table1 (Col1 INT) --2 INSERT INTO Table1(Col1) SELECT SomeCol FROM SomeTable --3 ...
2
votes
1answer
2k views

installing SSDT

I am preparing the MCSA 70-763 exam. I need to install the SSDT to deploy my pacakges into sql server. I am beginner and have 0 experience with VS and SSDT. When I tried to install SSDT from Sql ...
1
vote
1answer
344 views

Visual Studio SSDT Unresolved reference to SSISDB

I have a stored procedure in Visual Studio SSDT Project which use SSISDB database. And I get a warnings like "unresolved reference to SSISDB". I tried to create a new reference but I can only select "...
1
vote
1answer
752 views

How to refresh reference to objects in Visual Studio SSDT?

I have an issue related to missing reference to tables or views which exist in Visual Studio SSDT. For example I have two SSDT projects. One for database X second for database Y. In project X I've ...
3
votes
1answer
1k views

SSDT slow locally

When I use SSDT to update my local DB, it takes 3 minutes, during which Visual Studio is thrashing the CPU. When I use it from my computer to update an identical remote DB, it takes only half a minute,...
0
votes
2answers
499 views

Why does SSDT deploy inline FK Constraint as WITH NOCHECK?

Given the following Foreign Key Constraint definition inline of a Create Table definition in a SSDT project: CREATE TABLE A (...Columns...), CONSTRAINT [FK_O] FOREIGN KEY ([OID]) REFERENCES [dbo].[O] ...
0
votes
1answer
463 views

Enable Service Broker when deploying solution

I'm having an issue deploying the latest build of a database solution after creating some service broker objects. I am thinking that it could be related to not having service broker enabled on the ...
0
votes
1answer
463 views

SQLPackage.exe not picking up changes

I'm trying to get SQLPackage for schema compare working from CMD line. Have to compare a master db to 300 live dbs. All 2014 SQL and none registered as data-tier applications. PowerShell and 3rd ...
3
votes
1answer
251 views

Can SSDT deploy SQL server service broker objects?

Can SQL Server Data Tools (SSDT) deploy sql server broker objects? (So contacts, message types, services, queues and so on.)
1
vote
2answers
3k views

Connect SQL Server 2016 SSDT with TFS

I've just upgraded the SQL client tools on my PC to SQL Server 2016. I no longer have a "Team" menu option in SSDT. Under Tools > Options > Source control there is a drop down box for Source ...
2
votes
1answer
223 views

Adding Partitions to cube In SSAS via VS 2013

I am trying to add a new partition to my cube via SSDT 2013. I am using the Wizard and doing all stages that needed. After I click "Finish" nothing happens and I cannot see that a new partition has ...
1
vote
2answers
205 views

Linked Server works on SSMS and isn't found on SSDT

My Microsoft SQL Server has a linked server to another SQL Server. I have a simple query that runs on mine, deleting a remote table (truncate doesn't work) and inserting data to it. This query works ...
5
votes
1answer
3k views

How to prevent SSDT publishing from dropping columns

I want to create a publishing profile that DOES a complete schema comparison and publishing BUT does not drop any tables or any columns that have been removed between the old and new version. I am ...
0
votes
1answer
259 views

Generate DACPAC diff using predefined config

I would like to generate a diff file based on the database vs DACPAC comparison. Currently what I am doing is extracting DACPAC from the target database and trying to create a diff file based on that (...
1
vote
1answer
432 views

SSDT - Unresolved Reference to temporary table in linked server

Here's the scenario. I am extracting data from a table in an Oracle database via a linked server as part of an ETL process. I am developing the solution in Visual Studio 2013 with SQL Server Data ...
3
votes
2answers
119 views

Separate license needed for Visual Studio 2012 SQL Server database projects? [closed]

We have SQL Server 2014 Standard Edition and would like to use Visual Studio 2012 Database Projects for version control. Do we need to purchase a license to use VS database projects? Or is it ...