No announcements
-
0 VotesSQL login failed with correct password only in SSMS
My Server is in XYZ domain. I RDP to the Server using ABC domain credentials . I am trying to connect to a SQL server default instance using SQL authentication and using ...Unanswered | 5 Replies | 74 Views | Created by Vivek Janakiraman - Wednesday, September 20, 2017 2:03 AM | Last reply by Vivek Janakiraman - 3 hours 55 minutes ago
-
0 Votes
SQL Compare and Update in Visual Studio 2017 Issue(s)
On a new Dell i7 8GB RAM SSD Windows 10 box, I have Visual Studio 2017 Professional. I have the following issue. Using VS2017, I right click the database project and select Schema ... -
0 Votes
Visual Studio 2015 Database Project - Ignore schema authorizations
Hi, I'm creating a database project from an existing database. For us developers, we only care about the objects like tables, sp's, views, indexes, etc... but we want to ignore all ...Unanswered | 2 Replies | 84 Views | Created by RicardoMDC - Thursday, September 14, 2017 3:00 PM | Last reply by RicardoMDC - 14 hours 52 minutes ago -
0 Votes
Alternate for ScriptingEngine.AddProjectReference (VS 2008) for SSDT 2014
I am trying to create a script task using C# code for SSDT 2014. I am unable to find the ScriptingEngine.AddProjectReference (of SSIS 2008) in SSDT 2014. Could you please help me in this regard. ... -
0 Votes
SQL Server 2016 SSDT Script Task error
Software being used as provided by Help | About... Visual Studio 2015 Shell (Integrated) Version 14.0.23107.1 ...Unanswered | 4 Replies | 101 Views | Created by agundrum - Tuesday, September 12, 2017 6:54 PM | Last reply by agundrum - Wednesday, September 20, 2017 7:40 PM -
0 Votes
CDC - Net Change Function - How Do We Make It Faster?
I am currently testing a CDC proof of concept. I enabled CDC on a single table and the CDC all function (i.e. fn_cdc_get_all_changes) performs within reason. However, the CDC net function ... -
0 Votes
VS 2017 15.3.5 - unsupported SSAS and SSIS ?
Hi, I just installed the update of VS 2017 15.3.5 Now i can't load my project SSIS and SSAS. test with repair SSDT , KO. ( SSDT ... -
0 Votes
SSIS - Script component empty
Hello, Sometimes , when i want modify my script component (source), the component is empty like the first time. No variables in read or write section, and ... -
0 Votes
Visual Studio 2015 and Database Projects
I have a Database project under which I've added a number of scripts that add SQL Agent jobs to my servers. I can connect to a particular server then execute the script to add or update the ...Unanswered | 1 Replies | 53 Views | Created by Nick Ryan - Tuesday, September 19, 2017 8:24 PM | Last reply by Joyce Yin - Wednesday, September 20, 2017 7:34 AM -
0 Votes
Columnstore Indexes missing in Schema Compare
Application-scoped) is checked. I am able to see the differences in the schema compare if I "show equal objects" but have found no way to get the difference to be ... -
0 Votes
Loosing Salesforce connection while importing package to Sql Server Data tool 2014
Hi All, We are migrating all our SSIS packages from 2008 to 2014. One of our package uses Salesforce connection (Cozyroc). It works fine and am able to deploy to SSIS catalog ... -
1 Votes
Schema compare not updating DB Project
When running the schema compare in SSDT it will successfully run and recognize the changes. However, when I click 'Update' it will go through its process and say the Target was updated without ...Unanswered | 1 Replies | 483 Views | Created by ORIX USA Developer - Wednesday, January 28, 2015 9:49 PM | Last reply by Mike Diehl - Tuesday, September 19, 2017 3:32 PM -
29 Votes
Business Intelligence BlockMixedArchitectureInstall Error
Hi, when installing the SSDTBIVS2012 Business Intelligence Studio I always get a very useless "BlockMixedArchitectureInstall" error that tells me I ...Answered | 10 Replies | 11574 Views | Created by Markus Pöhler - Thursday, July 18, 2013 9:41 AM | Last reply by pinkyj12 - Tuesday, September 19, 2017 5:53 AM -
0 Votes
SSDT VS 2013 - Unresolved Reference to Object
Hi All, Is there any reason why the "Unresolved Reference to Object" in a stored procedure is treated as a warning, while in a view it's treated as an ...Unanswered | 1 Replies | 54 Views | Created by Andreyni - Monday, September 18, 2017 2:39 PM | Last reply by Lin Leng - Tuesday, September 19, 2017 4:40 AM -
0 Votes
SSDT 2015 cannot ODBC data flow on SQL Server 2016 SP1 - missing ODBC component
Hello We're struggling with the following: packages developed using SSDT 2015 run fine on all of the developer machines, we can successfully publish to our servers, but fail when we ... -
0 Votes
Error by Import BAKPAC (data-tier application) from Azure in local SQL instance
I have read much topic's about an error while importing a Azure database in my local instance, but I can't find a solution :(. I have install different SQL Server versions ...Unanswered | 1 Replies | 77 Views | Created by RPR84 - Saturday, September 16, 2017 5:43 PM | Last reply by Velmurugan.Sundaramoorthy - Sunday, September 17, 2017 1:23 AM -
73 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 | 34 Replies | 13149 Views | Created by ekephart - Monday, March 07, 2016 10:31 PM | Last reply by Xavier Fischer - Friday, September 15, 2017 9:31 AM -
0 Votes
SSDT VS 2013 - Scheme compare, issue with database references
Hi, when I use database references in my DB project and run a scheme compare against a DB I get a difference for the objects I have just ... -
1 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 ... -
27 Votes
Visual Studio 2017 SSDT's - Business Intelligence Tabular Projects/Solutions, SSIS
I just installed Visual Studio 2017 RC, and installed the new SSDT's 17.0 RC1 I cannot open Tabular Projects and cannot find the Business Intelligence Templates inside Visual ...Proposed | 16 Replies | 10716 Views | Created by Nine Dynamics - Sunday, December 18, 2016 4:28 AM | Last reply by Brad Syputa - Tuesday, September 12, 2017 5:01 PM - Items 1 to 20 of 3565 Next ›
No announcements
