No announcements
-
0 VotesRunning a query in a View Designer results in an error, but running the same query in a Query window works
Hi everyone, Just as my title says, I have a query which I've written in a query window and it works perfectly. But when I try to add the query code into the view ...Unanswered | 2 Replies | 618 Views | Created by Radu G - Wednesday, March 04, 2015 11:24 PM | Last reply by Ian Dalrymple - 13 hours 8 minutes ago
-
0 Votes
Visual Studio generated code causing SSDT Script Task Error CA1405.
I uninstalled everything, SQL Server 2016, SSDT, Visual Studio, and anything else related to Visual Studio or SQL Server. Took a day for that and another day to reinstall everything again. ...Unanswered | 1 Replies | 35 Views | Created by agundrum - Friday, September 29, 2017 2:37 PM | Last reply by Tom Phillips - Friday, September 29, 2017 6:42 PM -
0 Votes
Visual Studio 2017 and SQL Database Project -> Microsoft.Build.Exceptions.InvalidProjectFileException when trying to deploy.
Hi, I have a new Windows 10 PC, and installed Visual Studio 2017 & Data Tools. (Both are version 15.3.5) I've created a simple solution ...Unanswered | 5 Replies | 101 Views | Created by joe dillon999 - Monday, September 25, 2017 1:02 PM | Last reply by Brad Syputa - Friday, September 29, 2017 3:56 PM -
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 | 6 Replies | 165 Views | Created by agundrum - Tuesday, September 12, 2017 6:54 PM | Last reply by agundrum - Friday, September 29, 2017 12:30 PM -
0 Votes
VS2013 : source method not found:void ERROR
Hi All, Visual Studio 2013 Premium Update 5 with SSDT has just been installed and when I added a source transformation select my SQL connection I get the following ...Unanswered | 4 Replies | 83 Views | Created by Cameronh - Wednesday, September 27, 2017 12:01 AM | Last reply by Cameronh - Friday, September 29, 2017 3:48 AM -
1 Votes
Problem when refreshing a Data Source View using Visual Studio 2017
Hi, I am using Visual Studio 2017 to modify an Analysis Services project. I have made a change (added a new column) to one of the underlying tables in the Data ...Unanswered | 1 Replies | 193 Views | Created by Janet A - Friday, July 07, 2017 2:05 PM | Last reply by JMEsteves - Wednesday, September 27, 2017 10:34 PM -
0 Votes
script task won't open editor in visual studio 2013
Hello everyone, I have an issue on editing Script Task in Visual Studio(VS) 2013. We use SSDT 2015 and SSMS 2014. When I click on Edit Script button of ... -
0 Votes
SSDT Publish Failure
Hi, We have been having an issue with the SSDT publish with the following error Publishing to database 'DB' on ...Answered | 1 Replies | 152 Views | Created by SQLUser1979 - Friday, July 14, 2017 7:00 PM | Last reply by SQLUser1979 - Wednesday, September 27, 2017 8:55 PM -
0 Votes
Sql Server Object Explorer: Backup Server connectios
Good afternoon, From time to time, my connections on the SQL Server Object Explorer simple disappear and I have to add them and organize them (since I can't rename the servers ...Unanswered | 2 Replies | 55 Views | Created by Ricardo Madaleno - Monday, September 25, 2017 4:31 PM | Last reply by Ricardo Madaleno - Wednesday, September 27, 2017 12:22 PM -
0 Votes
How to deploy an SSRS report with TargetServerVersion = SQL Server 2008, and keep the rdl XML formatted.
All of the XML in our reports is getting placed on one line when building for SQL Server 2008. Is there any way to fix that?Unanswered | 1 Replies | 52 Views | Created by jmaurier - Monday, September 25, 2017 7:48 PM | Last reply by David Adlington - Tuesday, September 26, 2017 8:18 AM -
0 Votes
VS 2015 - Tabular model - How to change default font size for measure editor window
Does anyone knows how to change default font size in measure edit window in Tabular project? -
0 Votes
Unspecified Error while executing SSIS packages .
Hello Team, I have 20M data row file and i am trying to load sql source to sql destination table and its getting failed because of below ...Unanswered | 2 Replies | 52 Views | Created by Ravishukla20 - Monday, September 25, 2017 7:57 AM | Last reply by David Adlington - Monday, September 25, 2017 8:49 AM -
4 Votes
After update windows including SQL 2012 SP2 unable to start SQL service/instance
We have SQL 2012 Ent 64 bit SP1 Window 2008 R2 Datacenter After update windows including SQL 2012 SP2 unable to start SQL service/instance and ...Answered | 5 Replies | 5409 Views | Created by ABDUL HAFEEZ MALIK - Monday, October 20, 2014 4:31 AM | Last reply by Luis A R - Monday, September 25, 2017 5:10 AM -
1 Votes
Not able to read dynamic name of flat file on ssis packages .
Hello Team, Please help me on reading flatfile name from directory . c:\sourcefolder\abc_mmddyyyyhhmmss.txt i wanted to read this file on ...Unanswered | 1 Replies | 64 Views | Created by Ravishukla20 - Sunday, September 24, 2017 5:00 AM | Last reply by David Adlington - Sunday, September 24, 2017 5:37 PM -
0 Votes
Data Loading is very slow on ssis packages
Hello Team, I have 400MB length flat file (SOURCE)and Destination is sql server 2015. and its taking appx 2 hours for complete loading .please find design on below screen shot ...Unanswered | 9 Replies | 84 Views | Created by Ravishukla20 - Friday, September 22, 2017 3:44 PM | Last reply by Ravishukla20 - Saturday, September 23, 2017 2:00 PM -
0 Votes
SSDT project publish failed on External Data Source
Hello Guys, I've faced with next error during sql SSDT project publishing: Cannot drop the external data source 'DataSourceName' because it is used by an external ...Unanswered | 1 Replies | 232 Views | Created by Oleksii Zatulskyi - Wednesday, November 16, 2016 3:00 PM | Last reply by KensDifz - Friday, September 22, 2017 2:43 PM -
0 Votes
SQL 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 | 119 Views | Created by Vivek Janakiraman - Wednesday, September 20, 2017 2:03 AM | Last reply by Vivek Janakiraman - Friday, September 22, 2017 12:50 AM -
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 | 133 Views | Created by RicardoMDC - Thursday, September 14, 2017 3:00 PM | Last reply by RicardoMDC - Thursday, September 21, 2017 1:53 PM -
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. ... - Items 1 to 20 of 3575 Next ›
No announcements
