No announcements
-
0 Votes
The imported project "C:\Program Files (x86)\MSBuild\ExtensionPack\4.0\MSBuild.ExtensionPack.tasks" was not found
Hi! I'm using Visual Studio 2013 Ultimate Update 4 with SSDT v12.0.50512.0. I don't see a newer update for the SSDT. I get this message when I try to load a .SQLProj ...Unanswered | 5 Replies | 3473 Views | Created by Hassan Gulzar - Sunday, June 7, 2015 11:56 AM | Last reply by CodeNewbie - Wednesday, November 27, 2019 1:06 AM -
0 Votes
SSIS package Odata connection error
The connection type "ODATA" specified for connection manager is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection ...Answered | 3 Replies | 898 Views | Created by Ola Adegboyega - Wednesday, July 24, 2019 8:28 PM | Last reply by ModyDIOP - Tuesday, November 26, 2019 11:46 AM -
0 Votes
'No longer updating this content'
Hi, The main documentation page for SSDT says: We're no longer updating this content regularly. Check the Microsoft Product Lifecycle for information ...Unanswered | 3 Replies | 575 Views | Created by Nick Darvey - Tuesday, November 26, 2019 5:11 AM | Last reply by Vaibhav-Chaudhari - Tuesday, November 26, 2019 6:01 AM -
0 Votes
Export .bacpac File Using SQL Package
Hello, This is the first time I'm attempting to use sqlpackage.exe. I'm attempting to export a few tables to a .bacpac file to import into Azure ...Unanswered | 1 Replies | 518 Views | Created by anelliaf - Monday, November 25, 2019 5:29 PM | Last reply by Israel Haylamicheal - Monday, November 25, 2019 7:32 PM -
0 Votes
SqlPackage dacpac deploy without user permissions
Hi guys Is there any way I can exclude Database User-only permissions in a publish deployment? I have used the ExcludeObjectTypes=Users;RoleMemberships option to ...Unanswered | 3 Replies | 615 Views | Created by warnerrj79 - Friday, November 22, 2019 2:46 PM | Last reply by warnerrj79 - Friday, November 22, 2019 5:35 PM -
0 Votes
Upload DAT file into SQL by using SSIS
Hi Guys, I want to upload the below DAT file into the below TEST table by using SSIS. Please help me. Thanks Create TEST ( id int not ...Unanswered | 6 Replies | 721 Views | Created by AranSQL - Wednesday, November 20, 2019 5:25 PM | Last reply by Olaf Helper - Friday, November 22, 2019 6:30 AM -
2 Votes
Difference in behaviors of SqlPackage.exe and Visual Studio w/ respect to computed columns
We are encountering an issue whereby the latest version of SqlPackage.exe produces a different script than our Visual Studio 2019 sqlproj in a scenario involving a function in a computed column. ...Unanswered | 10 Replies | 448 Views | Created by Adam Joseph Stone - Wednesday, November 20, 2019 7:32 PM | Last reply by Tom Phillips - Thursday, November 21, 2019 8:04 PM -
0 Votes
Timeout Importing Database
Now that Visual SourceSafe and Source Control Integration in SSMS will be deprecated we are investigating using Visual Studio 2017 and the SSDT solution to develop SQL Server Objects like ...Unanswered | 2 Replies | 678 Views | Created by Stig - Monday, October 16, 2017 12:31 PM | Last reply by Stig - Thursday, November 21, 2019 11:01 AM -
0 Votes
Unit Test Project in VS 2019
I have installed VS 2019 and created a SQL Database Project however I do not see the SQL Database Unit Test project. Was this removed from VS 2019 SSDT? I do see a U-SQL Unit test project ... -
0 Votes
Publish only changes from stored procedures and views from one database to another in Azure Repos
I have created a database project in visual studio that includes schemas, tables, stored procedures and tables. I've added them to source control in Azure Repos. I want to publish only the ...Unanswered | 1 Replies | 437 Views | Created by Sindu_9090 - Monday, November 18, 2019 4:37 AM | Last reply by Vaibhav-Chaudhari - Monday, November 18, 2019 6:26 AM -
0 Votes
SSRS 2014- Unable to deploy reports
Hi Guys, I am a starter in SSDT, so apologies first if my question is so basic. I am using SSDT 2014 in localhost. SSMS Server type: Database Engine with Server Name: my ... -
0 Votes
SQL Replication - Agent Jobs were missing for the subscriber
Hi, I'm having a SQL Server Replication running with a publisher and distributor in the same server with 7 other pull subscriptions in different physical locations. I had to a face ...Unanswered | 3 Replies | 454 Views | Created by Chama.Rana - Monday, November 11, 2019 9:40 AM | Last reply by Matt Bradley Mcr - Saturday, November 16, 2019 7:33 PM -
2 Votes
with a Database project with schema and post deploys, is there a way to NOT run the post deploy scripts (like a option)
with a Database project with schema and post deploys, is there a way to NOT run the post deploy scripts (like a option). I have a database project that also has ...Proposed | 3 Replies | 450 Views | Created by LanceLyons - Wednesday, November 13, 2019 8:14 PM | Last reply by Tom Phillips - Thursday, November 14, 2019 8:49 PM -
3 Votes
SSDT 2015 - SSIS Toolbox - 'Azure' is greyed out
I have installed SSDT from the download-sql-server-data-tools-ssdt I have also installed SSIS Feature Pack for Azure for SQL Server 2016 Also, clicked on 'Azure' ...Answered | 5 Replies | 4546 Views | Created by JayLo37209 - Wednesday, May 17, 2017 7:56 PM | Last reply by Shivendoo Kumar Dubey - Thursday, November 14, 2019 6:12 AM -
0 Votes
SQL Server Database Project Support for Azure SQL DB?
Does Microsoft Visual studio 2017/2019 data tools supports SQL Server Database Project for "Azure SQL DB" and "Azure SQL ...Unanswered | 2 Replies | 277 Views | Created by Liyasker Samraj K - Wednesday, November 13, 2019 12:39 PM | Last reply by ErikEJ - Wednesday, November 13, 2019 1:37 PM -
0 Votes
Stored Procedures allow use of unsupported SQL functions for the target Database Platform
I have a SQL Server database project which is set to target SQL Server 2008 as its Target Platform. In one of my stored procedures, I have code as ...Unanswered | 0 Replies | 281 Views | Created by Laurence Frost - Wednesday, November 6, 2019 12:56 PM -
1 Votes
Referencing an unexisting column does not make SSDT build fail
Hello, Lately, we had an issue that made table columns cleanup more difficult. Some remaining column references in stored procedures didn't not make SSDT build ...Unanswered | 1 Replies | 422 Views | Created by Klébert Hodin - Wednesday, April 4, 2018 8:51 AM | Last reply by Uniqas - Tuesday, November 5, 2019 9:06 AM -
0 Votes
update database using Sql Server data tool
Environment: Visual Studio 2017, Windows 10, SQL Server 2014 Hi, I am using SqlPackage.exe to upgrade a database. Database has two type of tables: user tables and ...Unanswered | 1 Replies | 330 Views | Created by EDISPHERE_vijay - Monday, November 4, 2019 8:35 AM | Last reply by Guoxiong - Monday, November 4, 2019 3:32 PM -
0 Votes
Get error messages in VS2017(SSDT)
I open a solution with VS2017(SSDT), and when I preview one report in VS2017, I will get an error message like: An attempt has been made to use a data extension that is either not ... -
0 Votes
PDF Data Source in SSIS
Hi : I'm wondering it's possible using pdf how data source in SSIS. I've tried converting to another flat file, but I' haven't been able. Please is someone have a script to convert pdf ...Unanswered | 0 Replies | 282 Views | Created by Alfredo Garcia Diaz - Sunday, November 3, 2019 6:42 PM
No announcements