No announcements
-
0 VotesDacFX Deploy ignores SQLCMD Variables for
It appears as if setting the DefaultDataPath and DefaultLogPath in the SqlCommandVariableValues of the DacDeployOptions object has no effect on the data file and log file location. From ... -
0 VotesSSDT Import Into a Model using SQL (Visual Studio 2017)?
Hi there, I'm using Visual Studio Enterprise 2017, with the SSDT Plugin. When I want to Import Data from SQL Server Data Source, I can connect ...Unanswered | 3 Replies | 198 Views | Created by Adam T Summers - Wednesday, August 23, 2017 2:27 AM | Last reply by Praveen Y - Monday, October 02, 2017 6:23 PM -
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 | 645 Views | Created by Radu G - Wednesday, March 04, 2015 11:24 PM | Last reply by Ian Dalrymple - Saturday, September 30, 2017 12:17 PM -
0 VotesVisual 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 | 52 Views | Created by agundrum - Friday, September 29, 2017 2:37 PM | Last reply by Tom Phillips - Friday, September 29, 2017 6:42 PM -
0 VotesVisual 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 | 150 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 VotesSQL 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 | 183 Views | Created by agundrum - Tuesday, September 12, 2017 6:54 PM | Last reply by agundrum - Friday, September 29, 2017 12:30 PM -
0 VotesVS2013 : 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 | 105 Views | Created by Cameronh - Wednesday, September 27, 2017 12:01 AM | Last reply by Cameronh - Friday, September 29, 2017 3:48 AM -
1 VotesProblem 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 | 208 Views | Created by Janet A - Friday, July 07, 2017 2:05 PM | Last reply by JMEsteves - Wednesday, September 27, 2017 10:34 PM -
0 Votesscript 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 VotesSSDT 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 | 166 Views | Created by SQLUser1979 - Friday, July 14, 2017 7:00 PM | Last reply by SQLUser1979 - Wednesday, September 27, 2017 8:55 PM -
0 VotesSql 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 | 73 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 VotesHow 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 | 71 Views | Created by jmaurier - Monday, September 25, 2017 7:48 PM | Last reply by David Adlington - Tuesday, September 26, 2017 8:18 AM -
0 VotesVS 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 VotesUnspecified 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 | 68 Views | Created by Ravishukla20 - Monday, September 25, 2017 7:57 AM | Last reply by David Adlington - Monday, September 25, 2017 8:49 AM -
4 VotesAfter 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 | 5449 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 VotesNot 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 | 75 Views | Created by Ravishukla20 - Sunday, September 24, 2017 5:00 AM | Last reply by David Adlington - Sunday, September 24, 2017 5:37 PM -
0 VotesData 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 | 98 Views | Created by Ravishukla20 - Friday, September 22, 2017 3:44 PM | Last reply by Ravishukla20 - Saturday, September 23, 2017 2:00 PM -
0 VotesSSDT 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 | 255 Views | Created by Oleksii Zatulskyi - Wednesday, November 16, 2016 3:00 PM | Last reply by KensDifz - Friday, September 22, 2017 2:43 PM -
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 | 131 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 VotesSQL 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 ... - Items 1 to 20 of 3576 Next ›
No announcements
