sql-server-data-tools Questions
3
Solved
We have a solution with three database projects. All three produced dacpacs are deployed sequentially but for some reason, one of these dacpacs does not run the post-deployment script.
We're using...
Berriman asked 7/6, 2013 at 10:12
15
I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly...
Hardunn asked 23/4, 2014 at 8:50
4
Solved
I have a Visual Studio database project (DACPAC) which includes a number of SQL Sequences. However when I deploy the DACPAC it always resets the sequence value to the default value included in the ...
Labiovelar asked 1/12, 2015 at 11:34
5
Solved
I executed an SSIS package using SSDT and Visual Studio. When I try to execute another package I get an error saying "The process cannot access the file XXXX.ispac because it is being used by ...
Iliac asked 7/3, 2019 at 19:26
3
Solved
I have a SQL Project in Visual Studio 2017 and I'm using SSDT to update my project from a SQL Database, looks like this:
Often the database I'm using as my source is changing(often in small and ...
Twinflower asked 18/4, 2018 at 20:53
3
I am using Schema Compare feature in Visual Studio 2017 to compare a database with database project (.sqlproj).
If I apply some changes to the project it also adds blank lines to some of the schema...
Pictorial asked 20/4, 2018 at 14:59
5
Solved
I am attempting to install SSDT v15.6.0 into an existing Visual Studio Team Explorer 2017 instance. When I run the SSDT installer, I can select Visual Studio Team Explorer 2017 from this list of ex...
Sunil asked 16/5, 2018 at 20:48
10
This question was asked here before but the solutions proposed don't seem to be working for me.
I'm trying to import a text file pipe delimited text qualifier ". The SSIS package is returning the ...
Fabio asked 4/6, 2017 at 23:18
2
Solved
I'm setting up database projects for the first time and I'm trying to build/deploy using Azure DevOps. I'm using the MSBuild task hosted in Azure (windows-2019) for the build. I'm using a Command L...
Killarney asked 25/3, 2020 at 20:7
12
Solved
I created SQL Server Database Project in VS 2012 & imported our database.
When I build the project, I get a lot of "unresolved reference to object" Errors.
These errors are only for a few views...
Spruill asked 14/11, 2012 at 5:1
5
Solved
I recently deployed a update to one of my SSIS projects, and ever since the project has failed it's scheduled runs.
The SSIS package appears to be stuck at the "Created Execution" status. There ar...
Bivalve asked 17/6, 2015 at 18:4
6
Solved
I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the destination server (not optimal, but it works).
Wh...
Vaticide asked 5/6, 2012 at 21:11
5
Solved
In our SSDT project we have a script that is huge and contains a lot of INSERT statements for importing data from an old system. Using sqlcmd variables, I'd like to be able to conditionally include...
Wilbertwilborn asked 10/5, 2016 at 16:1
2
Solved
I am using the Microsoft Data-Tier Application framework to create a deployment script based on a DacPackage object. I am attempting to use the Microsoft.SqlServer.Management.Smo.Server class to ex...
Portent asked 28/10, 2014 at 19:49
7
Solved
I'm building an ASP.NET Core 2.0 Web API application that is hosted in an Ubuntu environment. So far, I've had great success getting things building and running (for the .NET Core app) in Ubuntu.
...
Oakie asked 27/1, 2018 at 22:5
4
I have a .sql scripts which is pretty huge. I added this script to a sql server project under visual studio 2013. When I try to build it I got this error message
This T-SQL script exceeds the m...
Zawde asked 1/6, 2015 at 10:50
5
Using:
Windows 7 Enterprise; Visual Studio Pro 2017 (15.3.5); SSDT 15.1
Can't get Data Viewer to pop up on my SSIS package. I did do some Google-fu, and can't find anything relevant (or newer than...
Fruiterer asked 3/10, 2017 at 20:40
5
Solved
Everything about my VS 2013 install appears to be working correctly except when I right click on a table in Server Explorer. I am trying to use the data tools to view the table, which is in a MS SQ...
Montsaintmichel asked 14/2, 2014 at 14:4
3
Solved
We are using Sql Server database projects to create deployment scripts from DacPac using SqlPackage.exe. We have different SQL Server Filegroups setup in various environments.
When deploying we ex...
Mulderig asked 28/2, 2017 at 1:41
3
Solved
In my Post Deployment Script, I would like to include all script files in a folder using a wildcard like this:
:r .\$(ReleaseName)\*.sql
Is there a way to do this? I can't find any..
Entice asked 13/3, 2014 at 14:29
2
Although I can find (on the web) a lot of information about the PreDeploy and PostDeploy Build Action for SQL scripts in a Visual Studio 2012 Database project and I understand that None does not co...
Kinney asked 11/8, 2016 at 13:8
5
In our VStudio 2015 solution we have a series of SSDT's. One of them is returning the exception "The "SqlBuildTask" task failed unexpectedly. Microsoft.Data.Tools.Schema.Sql.Build.BuildFailedExcept...
Layfield asked 29/9, 2016 at 15:47
10
Solved
I'm attempting to use SSDT to publish to a SQL Server database in Azure. When I do so, I am seeing the following error:
Unable to connect to master or target server 'DATABASE_NAME'. You must hav...
Decreasing asked 13/10, 2017 at 18:15
5
Solved
I think I was using visual studio 2017 and wrote a SSIS package. Now I installed visual studio 2019 and can't open the solution file. Error:
Unsupported This version of Visual Studio is unable t...
Obryan asked 12/9, 2019 at 20:52
5
Solved
In SSDT project (using VS2017/VS2015, SSDT version 15.1.61702.140), I cannot get my project to build. The compiler keeps complaining about the sql statement in my PostDeploymentScript (yes, I have ...
Grappling asked 11/5, 2017 at 20:58
1 Next >
© 2022 - 2024 — McMap. All rights reserved.