sql-server-data-tools Questions
2
Solved
We are implementing Power BI with SSAS Cube Direct Query. For some reason, SSAS Power BI is extremely slow performance, however using SSDT SSAS Application or Power View or Excel is Much faster.
I...
Seaside asked 2/4, 2019 at 23:4
2
Solved
I am creating a new SQL CLR using Visual Studio 2013 and in the Project Properties have set the Default Schema to 'decASM' (was 'dbo'). When I make this change and rebuild the project VS generates ...
Copyright asked 13/1, 2016 at 15:34
1
Solved
I am trying to build a database project where I was trying to create a system-versioned table within my Visual Studio 2017 solution, but I am suddenly getting an error:
SQL46010: Incorrect synta...
Metallography asked 9/4, 2019 at 9:58
2
I have a Script component (Script Transformation), which I need to be able to fail the DFT, i.e. the Data Flow Task that it is part of.
I am firing an error like this
try
{
// Does some work h...
Substandard asked 18/6, 2013 at 8:58
2
Solved
This is my first experience with SSIS so bear with me...
I am using SSIS to migrate tables from Oracle to SSMS, there are some very large tables I am trying to transfer (50 million rows +). SSIS i...
Swoon asked 22/3, 2019 at 15:46
1
Solved
I have a SQL Server project in VS and SSDT, and am scripting out a stored procedure that has to reference system objects (sys.tables, sys.all_columns, etc.). But when I build the project I get tons...
Tynishatynwald asked 13/3, 2019 at 19:55
2
Solved
It all started with the VS2017 runner type within TC. It was failing without any errors or hints (except the (default targets) -- FAILED. message on the solution level). I narrowed it down to the ....
Bucaramanga asked 26/7, 2017 at 9:37
3
In Visual Studio 2012 we have new project type called SQL Server Database Project and when compiled will create a .dacpac output file.
A Google for this term will link it with Data-tier Application...
Saliferous asked 9/12, 2013 at 13:7
1
Solved
I have a Visual Studio 2015 solution containing a Reporting Services project (*.rptproj) that used to build fine on our TFS Build Server.
I upgraded the solution to Visual Studio 2017, and now it...
Coaster asked 1/2, 2019 at 1:17
1
Solved
After clearing out my temp folder in an effort to free up some much needed disc space, my Sql Server Data Tools (SSDT) in Visual Studio 2012, no longer builds my data project and Schema Compare is ...
Managua asked 22/12, 2017 at 15:1
2
Solved
I have a VS2013 solution with *.sqlproj project that contains objects specific to this solution. The issue is that this is database common also for other projects.
My problem is to automatically d...
Expansionism asked 8/5, 2014 at 18:45
2
Solved
I need to run some analysis on my queries (specifically finding all the tables which a ssis calls).
Right now I'm opening up every single ssis package, every single step in it and copy and pasting...
Ha asked 14/1, 2019 at 12:12
1
When i try to open the SSAS project file, visual studio 2015 throw the following exception:
'projectfile.dwproj` cannot be opened because its project type (.dwproj) is not supported by this versio...
Sechrist asked 12/1, 2019 at 16:3
2
Solved
I'm using Visual Studio 15.8.5 with Sql Server Data Tools 15.1.
I've created an SQL Server database project and imported the schema of an already existing database. I've made several minor change...
Superfecundation asked 23/11, 2018 at 16:29
2
Solved
When trying to apply a DACPAC to an Azure SQL Database I'm getting the following from sqlpackage.exe:
*** An error occurred during deployment plan generation. Deployment cannot continue.
The El...
Marashio asked 13/5, 2018 at 10:21
1
Solved
I am getting a unresolved reference in a SQLProject, the error occurs on the create line. All objects are causing it because they are all being created in a specific schema.
For example I have Tabl...
Hartzel asked 15/11, 2018 at 0:20
9
I'm trying to install SQL Server Data Tools - Visual Studio 2015, but I keep getting an "Unspecified error".
The log file is at https://drive.google.com/open?id=0B3CEKzS2Sw8OODNJOXZJVGRWQlU.
I ...
Misfeasance asked 12/10, 2016 at 14:7
3
Solved
I am using SqlPackage.exe for my deployment. I have read the documentation here for the usage of SqlPackage.exe.
The documentation only states the synax for one variable:
Specifies a name value...
Combine asked 19/3, 2013 at 14:47
3
Solved
Trying to do something simple Data Compare in SSDT but proving a bit hard.
In one database, I have two tables I want to compare.
These tables have the same schema, just different table names. And...
Fiona asked 6/3, 2014 at 9:46
4
Solved
We have two software projects that both communicate with a single database. Right now SQL updates are all done on the database and it's relying on developers to make sure to update both sets of pro...
Erie asked 22/6, 2015 at 20:37
1
Solved
I've read a whole bunch of different forums on this but cant seem to get mine to work. I need to transfer a file from my local machine to an SFTP server using SSIS. Here is what I've already done:
...
Polyclitus asked 24/9, 2018 at 14:51
4
The title says it all but for further details. When i use the schema compare tool in VS2015 for my SSDT Project and my database on a server. The compare results always come back with the Users as b...
Chlorine asked 3/12, 2015 at 19:40
6
Solved
I do not see an option to create an SSIS project using Visual Studio 2017.
Sunfast asked 28/4, 2017 at 21:33
2
Solved
In PowerShell I'm using Microsoft.SqlServer.Dac.DacServices and Microsoft.SqlServer.Dac.DacDeployOptions to deploy/update a database DACPAC. The problem I am having is finding where to set the SQLC...
Rapallo asked 18/2, 2015 at 16:42
1
Solved
I have an existing database (SSDT project as source) where I have to update a table in. I'm only changing a column type from nvarchar(MAX) to nvachar(256). The problem is, that I have an existing v...
Externality asked 11/6, 2018 at 14:38
© 2022 - 2024 — McMap. All rights reserved.