sql-server-data-tools Questions
8
Solved
I'm trying to run a schema comparison using Visual Studio 2013.5 with SQL Server Data Tools 12.0.50730.0 against a SQL Server 2016 (13.0.300) Express database.
I can configure the source connectio...
Dam asked 26/8, 2015 at 17:44
3
Solved
We have some automated dacpac deployment code which correctly handles both a CreateNewDatabase and straightforward Update database scenarios in C# using Microsoft.SqlServer.Dac
Now in the CreateNe...
Cupellation asked 25/3, 2017 at 21:40
3
I have a very strange issue happening that is causing Script Task code to clear out. I have been able to test on 2-3 different machines. We are running SSDT 15.4 preview. The steps to reproduce wer...
Suite asked 5/2, 2018 at 19:50
1
Using Visual Studio database projects (SSDT) I added a new column to an existing table. I am using Always Encrypted to encrypt individual columns. When I add the column and try to publish, I get a ...
Delanos asked 30/4, 2019 at 16:13
0
I'm able to install SSAS and SSRS for VS2019 but the big problem is that the SSIS fails in installation and also i cannot know the error because it mentionned unknown error result: 0x80131500 i hav...
Interatomic asked 5/7, 2020 at 10:47
2
I recently had troubles Importing a Database from a SQL Server Database Project in VS 2015. Just hoping this helps some folks. I will add more pictures when my rep is higher.
Error I get:
The ser...
Lubalubba asked 13/4, 2017 at 16:21
1
Solved
I have Microsoft Visual Studio Professional 2015 installed on my machine, i also have SQL Server 2017 installed.
I am trying to install SQL Server Development Tools for BI projects on my machine,i...
Excommunicatory asked 30/5, 2020 at 6:7
2
Solved
When doing a Data Compare using SQL Server Data Tools through VS 2013 pro, I have a scenario where some tables appear to be getting missed out.
What I mean by that is there is data in TableA on t...
Femineity asked 29/6, 2015 at 12:17
5
Solved
I have many .sqlproj projects that need to be built on our build server. I don't want to install all of Visual Studio on the build server just so I can install SSDT to build these. How can I build ...
Caldarium asked 21/3, 2013 at 19:25
2
Solved
I have a SSIS package that talks to a remote server over HTTP. I execute the SSIS package using a stored procedure in my database (SQL Server 2012), which is called from a web server. The web serve...
Archaic asked 14/1, 2019 at 21:32
1
Solved
I have a table valued function that I'd like to add to my ssdt project.
create function dbo.fn_get_n_geos(@p0 nvarchar(max),@n bigint)
returns table
with schemabinding as
return
select top(@n) ge...
Bannerman asked 23/5, 2019 at 19:24
3
Solved
Essentially, I encounter the same problem as the question below, except that the accepted answer does not resolve it. I have neither warnings nor errors in the Error List:
See complete tooltip err...
Socinus asked 17/4, 2019 at 20:28
1
I am new to Visual studio, and I am in the process of building my first tabular model in Visual studio, have been using powerBI for a year or so.
I have an Azure SQL database setup, with data tabl...
Psalm asked 19/3, 2019 at 16:35
2
Solved
Pretty new to BI and SQL in general, but a few months ago I didn't even know what a model is and now here I am...trying to build a package that runs daily.
Currently running this is Excel via Pow...
Farthermost asked 18/1, 2020 at 21:8
4
Solved
we get this error intermittently on all of our builds. Starting the same build again it runs OK with no errors. What does it mean, anyone knows?
msbuild arguments (some builds have UpdateDatabase=...
Loyce asked 2/10, 2014 at 7:8
3
Solved
Looking for a workaround for:
Error: SQL71609: System-versioned current and history tables do not have matching schemes. Mismatched column: 'XXXX'.
When trying to use SQL 2016 System-Versioned (...
Orientalism asked 2/12, 2016 at 20:46
3
Solved
When executing an SSIS package, the following error appears:
[OLE DB Source [83]] Error: The SQL command requires a parameter named
"@Sales_person", which is not found in the parameter mapping....
Shostakovich asked 25/4, 2017 at 19:20
8
Solved
I have create a report using visual studio 2015 with SSDT Tools installed from the following link
https://msdn.microsoft.com/en-us/mt186501
The database is on SQL Server 2014. The reports work o...
Streeter asked 10/3, 2016 at 16:56
3
From the Schema Compare Options, I deselected all Object Types:
It still shows me differences in Schema objects:
I scrolled through the big list of General options, and none of them appeared ...
Burhans asked 17/7, 2013 at 20:32
2
I'd like to know the difference between SSDT in Visual Studio and Integration Services in SQL Server. When developing SSIS package locally using SSDT in VS I could pass data to my local SQL Server ...
Openhanded asked 17/5, 2019 at 16:35
6
I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017
I get the following error (translated):
The requested meta file operation is not supported (0x800707D3)
...
Hypanthium asked 19/12, 2017 at 10:13
3
Solved
I have a new project that needs SQL Server unit test, and CI/CD with VSTS.
Below is the features that are required
SQL server unit test against stored procedure, initial target tables setup for ...
Correa asked 17/12, 2017 at 22:21
1
Solved
I am new using SSIS and want to create a script to connect to a Mongo DB, for this purpose I am trying to add a reference to a MongoDB driver as explained here
Unfortunately I don't see a way to d...
Closefitting asked 8/5, 2019 at 9:2
9
Solved
I am having an issue with the SSDT installation for VS2017.
I have ran the installer three times, once basic, once following VS update and the last following some minor windows updates.
All 3 tim...
Danit asked 26/9, 2017 at 8:40
4
I have found the installer for the VS2017 version here, but is there one for the 2019 preview version?
Habitant asked 15/2, 2019 at 10:29
© 2022 - 2024 — McMap. All rights reserved.