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.

learn more… | top users | synonyms

1
vote
1answer
38 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
0answers
54 views

SSDT Syntax Error 80001 on every Select statement starting with “(”

Visual Studio / SSDT marks the following script line as wrong giving "SQL80001 Wrong Syntax next to SELECT" and also "SQL80001 Wrong syntax next to ')'" error. (select a from [tab1]) union (Select a ...
1
vote
0answers
16 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
38 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 ...
3
votes
1answer
117 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
0answers
22 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 (...
0
votes
0answers
45 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 ...
2
votes
2answers
50 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 ...
2
votes
1answer
32 views

SSDT-BI SQL Version Compatability

I'm working on upgrading some SSIS packages from SQL Server 2008 R2 to 2012 and am getting somewhat confused by the SSDT-BI tools. I have downloaded "Microsoft SQL Server Data Tools - Business ...
0
votes
0answers
18 views

How does “OtherServer” in SSDT database references work?

I want to create a SSDT database project that is supposed to be deployed on a Sql Server that has several linked servers to other servers. The database ("MyBusinessDB") on those remote servers is in ...
2
votes
1answer
417 views

Error Updating SSIS package to 2014 due to script component

I am trying to update a SSIS package that contains script component. The script component just gets the error description as described here. I am using the update wizard in SSDT 2015 which should be ...
0
votes
0answers
56 views

Howto create useful dacpac versioning with along SSDT deployment?

Took me almost one day to go through lots of articles and blogs to realize check-in driven continuous integration with SQL Server Database Projects (SSDT) using TFS and msbuild. Now one this is ...
0
votes
0answers
20 views

Is automatic disabling of DML triggers possible during SSDT publish?

During ssdt deployment I am concerned about having DML triggers in place on tables that may slow down performance of table recreation a lot. We are facing the issue that the column order in the ...
0
votes
0answers
22 views

Howto create a detailed report of all actions by publishing with sqlpackage.exe?

When publishing ssdt projects from visual studio I realized that a "deploymentreport.txt" file is created on hard disk. sqlpackage.exe can be executed with the action "DeployReport" that creates a ...
1
vote
0answers
55 views

What can cause an “SCD is not compatible with this version of the DataFlow” error?

I created an SSIS package which includes several SCD data flows. This works fine in Visual Studio SSDT, but when scheduled (using SQL Agent), it fails, with this error repeated for each SCD: Code: ...
7
votes
2answers
420 views

Property class Length Annotation PersistedResolvableAnnotation

I am trying to deploy an ssdt project using sqlpackage.exe utility. I get the following error (in German): Fehler bei der Erstellung des Bereitstellungsplans. Die Bereitstellung kann nicht ...
1
vote
1answer
163 views

SSIS ODBC: Mapping result set columns to variables returns error “Value does not fall within expected range”

In SSIS 2012, I'm using an "Execute SQL Task" to call a stored procedure that returns a single row with two columns. I'd like to map that result set to two SSIS user variables. Should be easy, right?...
0
votes
2answers
45 views

SSDT table column order

I realized that the behaviour of SQLPACKAGE.EXE changes depending on what changes have been made to a table schema: Adding a new column at the end of the table: "Table is changed" Removing a column ...
0
votes
1answer
30 views

Howto remind and restore recovery mode during SSDT deployment?

Due to deployment of a SSDT database project I would like to be able to switch the target database's recovery mode from FULL to BULK LOGGED and back after the deployment finished in order to do any ...
0
votes
1answer
38 views

SSDT Publish Window: What does checkbox ENABLE mean?

In the Visual Studio 2015 SSDT "Advanced Publish Settings" Window, Tab General, "Advanced Deployment Options" there are several checkboxes in the column "ENABLED" we can check or uncheck. Most of the ...
0
votes
1answer
85 views

SSDT Not Dropping all Foreign Keys before Drop Table

SSDT V11.1.50730.0 Using Schema compare to make changes from my development environment to a test environment (a copy of Production). Part of the changes is the addition of columns to an existing ...
6
votes
1answer
106 views

Drillthrough action on semi-additive measure group

I have created a semi-additive (Last Non-empty) measure in a cube that I am developing. For that measure group I have created a drillthrough action. When I use that drillthrough action it is ...
2
votes
1answer
103 views

Run aspnet_regsql.exe from SQLCMD Post-Deployment Script

I am trying to create a Post-Deployment script in SSDT that will include the creation of an ASP.NET Session State database to make sure everyone has this thing in place after deployment of my database ...
2
votes
1answer
118 views

SSDT Schema Comparison for Stored Procedure signed by a Certificate

I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and it is finding that there are stored procedures that do not match with regard to ...
0
votes
2answers
71 views

Visual studio 2010 missing BI 2010 (SSDT 2010)

Where can I find a link to install SSIS 2010 ( SSDT 2010 or Business Intelligence 2010) I have VS 2010 on my machine.
1
vote
1answer
68 views

Post data deploy in SSDT

I need to create post deployment script which will upload data from .csv file to my database. But I can't understand how can I do this. When I tried to deploy my project on my server I receive this ...
3
votes
2answers
2k views

Schema Migration: SQL Server Data Tools vs Liquibase and Flyway

This might seem like a stupid question, but I've been looking into open source solutions for schema migration, namely Liquibase and Flyway. However, my boss told me that SQL Server Data Tools (SSDT) ...
1
vote
0answers
27 views

SSIS DTSPackageType behaviour

I created a new SSIS package within Visual Studio 2013 with SSDT BI Tools (12.04.2430.0) installed bu when looking into this package I can see that the DTSPackageType is set to DTSDesigner100. Based ...
4
votes
1answer
272 views

“Lock request time out period exceeded” when publishing SqlServer databases in parallel

I am working on a continuous integration environment using SqlServer2014. There I need to publish many SqlServer databases simultaneously on the same instance. Our publish process uses a .sqlproj file ...
1
vote
1answer
48 views

How to re-include excluded folder in SSDT-BI / Visual Studio 2013 database project?

I've selected "Excluded from project" on a folder with tables (database was imported first into project). Now I would like to re-include this folder into the project. In the "Add Existing Item" option ...
1
vote
1answer
45 views

Installing SQL Server Tools

In order to set up an SSAS system, I am having to install Visual Studio (SQL Server Data Tools - Business Intelligence) but when I adding this to the instance, it says it has failed the rule "Same ...
0
votes
1answer
71 views

How to Publish Checked-In changes only in Team Foundation Server 2013 to SQL Server?

I would like to ask you how to publish checked-in changes only in Team Foundation Server 2013 to SQL Server? It's a new installation of TFS 2013 - installed by me. Currently when I create new object ...
0
votes
1answer
36 views

Specify windows account for SSRS data source in SSDT project

In the properties of a data source in SSRS, I can specify a Windows domain account to use, like this: This data source was originally deployed from a SSDT project and I need these settings to be ...
3
votes
1answer
406 views

SSIS Control Flow: Precedence constraints not working as expected

The control flow of my SSIS package is not behaving as expected. What I want to achieve: Test if CLR is enabled on SQL Server using SELECT value FROM sys.configurations WHERE name = 'clr ...
1
vote
0answers
44 views

Date picker is dynamic in SSDT but not in SSRS

Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010) When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date (month/...
2
votes
2answers
451 views

Loading sql server 2014

Trying to load SQL Server and SSDT-BI from Visual Studio. Got the below error when loading SQL Server 2014 and apparently it caused the Reporting Services-Native to fail to load. I didn't take ...
3
votes
1answer
131 views

How to manage stored procedure dependencies in SSDT?

I have multiple stored procedures, some that depend upon others. When publishing my database, I receive an error when creating some stored procedures due to dependency issues. SSDT seems to be ...
2
votes
1answer
1k views

Script component source won't load when click “Edit Script…”

I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but ...
5
votes
1answer
501 views

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

I have worked a couple of times with post deployment scripts and always, intuitively used the build action "PostDeploy", because that is what it is. Now for the first time I try to follow the built-in ...
3
votes
1answer
961 views

SSDT project with working linked server references gets SQL71562 warning

I have a VS 2013 solution with two database projects. One of them, let's call it the "worker" is supposed to get deployed to about 10 different production servers. The other one, that is supposed ...
2
votes
1answer
135 views

SSDT: Create User in a database not being part of the project

I want the user of my SSDT Database Project to be created as a user in another database on the same server and give it permissions to connect and add it to the db_datareader role. I failed to do so. ...
4
votes
2answers
461 views

Excluding a specific table from a SSDT deploy

I have an existing database with everything in schema dbo. I have an SSDT project with objects I am adding to it with schema foo I have a table that looks like this in the project: CREATE table foo....
1
vote
1answer
2k views

“Unresolved reference to User” after importing as a VS DB project

I just imported an existing SQL Server 2008r2 production database into a VS 2013 database project. I now get a number of errors along the lines of Error SQL71501: User: [mydbuser] has an ...
2
votes
0answers
142 views

SSDT sqlpackage.exe CreateNewDatabase Parameter Not Respected

Originally asked this on SO but that question seems to be populated only by tumbleweed so wondered if this might be a better forum for it. I have a VS2103 solution which includes a database project ...
8
votes
1answer
575 views

SSDT Schema Compare fails when comparing my DB Project to my Azure Server

I have a SQL Database project that I have built our enterprise DB on. It has deployed several times on internal and AWS hosted SQL servers using SSDT's Schema Compare tool. The problem when I post ...
1
vote
0answers
876 views

SSIS Package Deployment Failure using SSDT

SSIS fails almost immediately on the final "Deploying project" step of the Deployment Wizard (Package Deployment Model), using Visual Studio 2010 (SSDT) connecting to a SQL 2012 Server: Failed to ...
10
votes
1answer
330 views

SSDT Schema Compare doesn't work while a BULK INSERT is in progress

I'm working at a large ETL and DW project where we use TFS/source control together with both SSIS and SSDT. Today, I found out that while an SSIS package is performing a BULK INSERT into a database ...
0
votes
1answer
108 views

SSDT schema compare, removing and then renaming stored procedure result is incorrect

The initial setup contains two scripts: stored_procedure.sql stored_procedureV2.sql What I did is: Remove stored_procedure.sql Rename stored_procedureV2.sql to stored_procedure.sql When I ...
2
votes
1answer
838 views

SSDT on VS2013 for SQL Server 2012

I have Visual Studio 2013, and SQL Server 2012. From what I'm reading, it seems that the SSDT add-in for VS2013 only works for SQL Server 2014. Is that correct? I've installed it, and I built a SSIS ...
0
votes
2answers
1k views

One SQL Server. One SSIS. Two versions of DTExec.exe?

Is it possible to install and use the 2012 version of the DTExec.exe on a Server 2008R2/SSIS2008 box without installing SSIS 2012? All jobs will be called from the command line, no server agent jobs. ...