sql-server-data-tools Questions
1
Having installed Sql Server Data Tools, I am attempting to use SqlPackage.exe from: C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\
I'd like to "extract" schema and data. This is so I can...
Mikkimiko asked 17/4, 2018 at 13:21
3
While comparing Database instance to a Database project in VS2010 using SSDT, it shows a difference in one of the Stored Procedures. The Store Procedure DDL script is exactly the same but when I ex...
Constantine asked 13/10, 2015 at 3:59
2
We're trying to migrate our old Reporting Services solution from Visual Studio 2008 with Business Intelligenge Studio, to Visual Studio 2017 with SQL Server Data Tools. The reports in the project a...
Psychophysiology asked 19/5, 2017 at 9:11
2
Solved
We are trying to work with temporal tables in SQL Server 2016. We are developing the SQL scripts in SSDT 15.1.6 in Visual Studio 2017, but we are experiencing issues when trying to deploy the dacpa...
Primary asked 30/3, 2018 at 15:36
4
Sql Schema Compare will not update after CLR object installed 'Source schema drift detected'
After installing a custom CLR object Sql Server Developer Tools (SSDT) VS2012 will not allow an update. The error is "Source schema drift detected. Press Compare to refresh. After refresh same thin...
Thithia asked 8/2, 2013 at 14:28
1
Solved
After extensively searching over google about SSDT and SSDT-BI for different SQL Server versions, I would like someone to pin-point differences and clear my messed up thoughts !
Aim: To upgrade SS...
Radmilla asked 26/2, 2018 at 9:6
2
My team/company tried out SSDT for a few small projects and we were quite impressed.
Recently we investigated use of SSDT for one of our larger existing applications and got FLOODED with SQL71501 ...
Crespo asked 28/1, 2018 at 15:54
1
During build we generate dacpac files of our database based on a SSDT .sqlproject. This dacpac later gets deployed to production using sqlpackage.
Despite using the /p:DropStatisticsNotInSource=Fal...
Hutt asked 9/3, 2017 at 9:44
2
Solved
I've created a SQL Server database project in Visual Studio 2013 and imported a DACPAC taken from a production database. When I tried to build the project I get hundreds of SQL71501 and SQL71561 er...
Azote asked 8/9, 2014 at 2:36
1
I am running SQL Server 2014 on my machine. I have installed SSDT for Visual Studio 2017, which I also have. Now I am not able to find the SSIS Toolbox in my Visual Studio. Do I need to re-install ...
Footlight asked 4/1, 2018 at 19:38
2
Solved
I'm trying to deploy a DACPAC to LocalDB 2012 but it's just not having it:
Stack trace is as follows:
==================================
Could not deploy package. (Microsoft.SqlServer.Dac)
----...
Desiccant asked 12/3, 2016 at 0:3
7
I was searching for Business Intelligence SSDT tools on Visual Studio 2013.
I found SSDT for Visual Studio 2012 here,
http://www.microsoft.com/en-in/download/details.aspx?id=36843
Can w...
Angele asked 25/1, 2014 at 13:42
2
Solved
I have the following two columns:
StartDate = 2017-01-01 00:00:00.000
EndDate = 2017-01-01 05:45:00.000
I need to write an SSIS expression for my derived column that will calculate the time betw...
Jarvisjary asked 14/12, 2017 at 15:38
3
For a build server, we need a headless install of SQL Server Data Tools, for Visual Studio 2017.
Our build servers already have "Build Tools for Visual Studio 2017", which provides nice support f...
Cockfight asked 23/10, 2017 at 22:6
4
Solved
I have the SSIS package, which will load the excel file into Database. I have created Excel Source task to map the excel column name to Database table column name and its working fine.
In rare cas...
Goldengoldenberg asked 22/11, 2017 at 14:45
1
Solved
If you have existing Report Server Project in your solution and you upgrade SQL Server Data Tools from version 14.0.61707.300 to 14.0.61709.290, you can get following message when opening your exis...
Ers asked 17/11, 2017 at 16:25
3
Solved
I've been successfully publishing DACPACs to SQL Server 2008-2012 instances using SqlPackage.exe, as installed by SQL Server Data Tools (and typically found in C:\Program Files (x86)\Microsoft SQL ...
Quenelle asked 29/4, 2014 at 21:36
2
I have just upgraded Visual Studio from 2017 to 2017.3. Now when I try to build I get this error on my database project:
Error: The imported project "C:\Program Files (x86)\Microsoft Visual Stud...
Shrieve asked 23/8, 2017 at 10:17
1
I have many temporal tables in my SQL Server database project. Today I upgrade my SSDT to the latest version and I got the following errors for temporal tables when building the project. For exampl...
Landeros asked 20/9, 2017 at 20:33
1
Solved
I have SSDT Tabular Project which needs to be deployed to Azure Analysis Services.
I created new role in tabular model explorer, but when I'm trying to add my group created in Azure Active Directo...
Recrudescence asked 13/9, 2017 at 23:30
3
Solved
I have all extensions disabled, and only 1 Sql Project open. Yet Visual Studio hangs whenever I close a SQL file.
Versions affected:
2017 Enterprise
2015 Enterprise
During this "hang ...
Carob asked 15/5, 2017 at 15:52
1
Tools: Visual Studio 2015, SSDT
I have an Visual Studio SQL Project which works fine on it's own. I run my build and the dacpac file is in debug\bin\*.dacpac as expected.
The problem is thi...
Guthry asked 10/9, 2017 at 18:46
5
Solved
I would like to exclude certain object, for example all logins & users, from extract or publish operation of sqlpackage.exe.
This is possible from within Visual Studio, so I hope it is also po...
Shortening asked 24/1, 2014 at 11:0
3
Solved
I have to import about 50 different types of files every day. Some of them with a few columns, some inculde up to 250 columns.
The Flat File connection always defaults all columns to 50 chars.
So...
Pragmatic asked 7/7, 2017 at 7:19
2
Solved
MSBuild 14.0 (the version included with Visual Studio 2015) logs warnings (MSB4078) when building a solution which contains SSDT projects (rptproj or dwproj projects). For example:
warning MSB40...
Million asked 2/5, 2017 at 10:16
© 2022 - 2024 — McMap. All rights reserved.