No announcements
Found 4641 threads
-
0 VotesHow to change the font size of the SQL script in the SQL Statement window in SSIS SQL task container
Environment>Font&color > Show settings for "Text editor". That doesn't work. Thanks! Deepali
-
0 Votes
Extended Events Question
How can I get the list of columns that are covered in a Session or the EventFile; (column type does not matter, I guess) Basically, I want to build that ...Unanswered | 5 Replies | 1842 Views | Created by Travis McGee - Saturday, August 3, 2019 2:29 PM | Last reply by TomerW - Tuesday, July 14, 2020 2:17 PM -
0 Votes
64 bit version of ssms
Hi, Is there a 64 bit version of ssms and from where can I install it? Regards FahadProposed | 8 Replies | 891 Views | Created by Fahad Arena - Tuesday, July 14, 2020 8:06 AM | Last reply by Enric Vives - Tuesday, July 14, 2020 12:55 PM -
25 Votes
Unable to Preview Oracle OLE DB Source in SSDT 17.2/VS2015
When using SSDT for VS2015 (17.2), I'm unable to preview any OLE DB data sources that use the Oracle OLE DB provider installed as part of the Oracle client. I've tested this on a ...Unanswered | 26 Replies | 13430 Views | Created by emorgoch - Tuesday, September 12, 2017 8:01 PM | Last reply by the47 - Monday, July 13, 2020 10:49 PM -
0 Votes
Is there a way in PowerShell to change the Out-File width max amount in a text file so that more than 1500 characters are put on one row without wrapping to the next row?
Hello, I am trying to out-file a lot of long lines SQL script into a text file and I need each line to be its own continuous line. What is happening is ... -
1 Votes
SSDT 16.4, SSDT for VS 2015 download
Hi, i need old version of the SSDT: 16.4, SSDT for VS 2015 Released: September 20, 2016 Build number: ...Unanswered | 4 Replies | 800 Views | Created by Dim4ik2222 - Friday, July 10, 2020 1:56 PM | Last reply by Dim4ik2222 - Monday, July 13, 2020 7:38 AM -
0 Votes
Compare data between two Azure SQL DB's
Hi, I have a requirement where i have to compare data between two tables from two different Azure SQL DB's, Both the DB's have same schema so i just need to compare the data, what ...Unanswered | 2 Replies | 1112 Views | Created by Shameerz4u - Thursday, June 18, 2020 10:31 PM | Last reply by Laxmidhar sahoo - Sunday, July 12, 2020 10:40 AM -
0 Votes
Is it possible to use SSDT data Compare Tool by code
I'm using SSDT compate tool in VS2019 to realize replication off 2 databases. I want to add this action in my VB application code. How can I add references to this tool and manage ...Unanswered | 3 Replies | 1313 Views | Created by Laurent Brugeaud - Tuesday, May 26, 2020 6:55 AM | Last reply by Andrew Stanton - Sunday, July 12, 2020 2:34 AM -
1 Votes
SQL Server Database Project - SQLCMD Variables with Closing square brackets
Hi All, I've created a SQL Server DB Project in VS2012, and created a SQLCMD Variable that contains a closing square bracket - ...Answered | 4 Replies | 13382 Views | Created by ObsidianPhoenix - Monday, April 29, 2013 12:15 PM | Last reply by rshadman - Wednesday, July 8, 2020 9:48 PM -
1 Votes
SSMS Source Control Plug-In
Options > Source Control > Plug-in Selection: 'Git' & 'TFS' & 'None' In SSMS I see: Tools > Options > Source Control > Plug-in Selection: ...Proposed | 14 Replies | 13157 Views | Created by Rusty Gates - Thursday, December 28, 2017 10:48 PM | Last reply by Tom Phillips - Tuesday, July 7, 2020 7:06 PM -
0 Votes
Tools used for effective SSIS and sql development and deployment
Hi. What are the visual studio tools which can be used under visual studio extensions for 1) code review check in SSIS and SQL Server ( stored ...Unanswered | 1 Replies | 651 Views | Created by Venkatzeus - Sunday, July 5, 2020 3:16 PM | Last reply by Olaf Helper - Monday, July 6, 2020 7:52 AM -
90 Votes
Schema Compare - Target unavailable
I'm experiencing a strange issue comparing schemas. I have VS2015 and am comparing two SQL2014 databases. After working fine for some time without explanation I now receive a message: ...Proposed | 48 Replies | 33656 Views | Created by ekephart - Monday, March 7, 2016 10:31 PM | Last reply by Ciro Corvino - Saturday, July 4, 2020 10:27 AM -
10 Votes
Unable to open ssis solution after updating SSDT
I have vs 2017 enterprise. I have ssdt 15.3 installed previously. Since there are several issues bothering me have been fixed in the latest ssdt 15.5.2, I decided to update. The ...Proposed | 8 Replies | 8108 Views | Created by needforAE86 - Saturday, March 31, 2018 4:05 AM | Last reply by Awil Gedi - Friday, July 3, 2020 2:27 AM -
0 Votes
Script editor will not work in Visual Studio 2017 SQL Server Data Tools
System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The token supplied to the function is ... -
0 Votes
Unresolved reference not being caught when joining temp tables (SQL71561)
When building a SSDT SQL Server Database Project project in Visual Studio 2019, The error SQL71561 is expected to raise when there is an unresolved reference in the schema. This is ...Unanswered | 1 Replies | 595 Views | Created by paulovila2 - Wednesday, July 1, 2020 12:55 PM | Last reply by Tom Phillips - Wednesday, July 1, 2020 7:16 PM -
0 Votes
SSRS 2005 backward compatibility with VS 2019 and SSDT 2019
We have a client that has to upgrade their Visual Studio License to 2019. The SQL and SSRS is still on 2005 and will not be upgraded as they will be moving to a new system in 2 ...Unanswered | 4 Replies | 776 Views | Created by Splaterniss - Friday, June 26, 2020 1:39 PM | Last reply by Splaterniss - Wednesday, July 1, 2020 10:26 AM -
0 Votes
BCP utility paramaters in Linux -o -outFile
I find a difference in format and parameters for bcp command between windows and linux. I want to understand -o parameter which is used to specify outFile is not supported ...Unanswered | 3 Replies | 926 Views | Created by Ram M R - Thursday, June 25, 2020 10:52 AM | Last reply by Laxmidhar sahoo - Friday, June 26, 2020 12:50 PM -
0 Votes
SQL Server Diagnostics not installing
Hi, I'm trying to install the 'SQL Server Diagnostics' tool but I get the error message 'You need to install SSMS 2016 or higher to continue installing', but I have the latest SSMS ...Answered | 3 Replies | 890 Views | Created by marqo - Wednesday, June 24, 2020 5:34 PM | Last reply by marqo - Thursday, June 25, 2020 7:10 PM -
1 Votes
SSIS Script Component fails within SQL Server Agent Job (SqlServer.Dts.Pipeline.ComponentVersionMismatchException)
Hi All, Environment: SQL Server 2016 Visual Studio 2017SSIS Data Flow Script Component (Type: Source, ScriptLanguage: Microsoft Visual C# ...Unanswered | 6 Replies | 5066 Views | Created by Ivan Sho - Friday, February 9, 2018 1:38 AM | Last reply by Shivendoo Kumar Dubey - Wednesday, June 24, 2020 1:34 AM -
0 Votes
how do I dispaly multiple parameter values (from one parameter) in report header
I currently have the following in my report header: ="Report for Order Type(s): " & Parameters!order_type.Value(0) and it works ...Answered | 1 Replies | 644 Views | Created by Tom Stone 98 - Friday, June 19, 2020 3:51 PM | Last reply by Olaf Helper - Friday, June 19, 2020 3:58 PM
No announcements
