Questions tagged [visual-studio-2013]
The visual-studio-2013 tag has no usage guidance.
22
questions
1
vote
1
answer
2k
views
Unable to find "Local" window while debugging SSIS package
I'm trying to debug my package in SSIS. I need to see the value of my variables while debugging, but the problem is that I cannot find the "Local" window. The only window I have is the breakpoint ...
user157749
0
votes
1
answer
73
views
Procedure returning different values
I have a procedure TempSalesUpdateID which gets all ProductName's column in TempSales table and set it's corresponding ProductID.
ALTER PROCEDURE [dbo].[TempSalesUpdateID]
AS
UPDATE T
SET T....
- 15
3
votes
3
answers
4k
views
Visual Studio database project and Enity Framework code-first
At work we are developing our latest module in C# Entity framework code-first approach. I have been given the role of developing databases from the DBContexts from within the project/s.
I generated ...
- 131
0
votes
1
answer
522
views
Visual Studio 2013 and up - Database Project Schema Compare File
Is there any reason to save the schema compare file once you are done comparing, creating scripts or just simply updating?
- 103
2
votes
1
answer
1k
views
SSDT - Unresolved Reference to temporary table in linked server
Here's the scenario.
I am extracting data from a table in an Oracle database via a linked server as part of an ETL process. I am developing the solution in Visual Studio 2013 with SQL Server Data ...
- 123
3
votes
2
answers
5k
views
SSIS: script task on Visual studio 2013 can not open since Visual Studio 2015 was installed
Until the installation of Visual studio 2015, it was always opening Visual studio 2012.
Attached the only error he throws, It seems he was trying to open Visual Studio 2015.
- 219
1
vote
0
answers
69
views
SSIS DTSPackageType behaviour
I created a new SSIS package within Visual Studio 2013 with SSDT BI Tools (12.04.2430.0) installed bu when looking into this package I can see that the DTSPackageType is set to DTSDesigner100. Based ...
- 2,877
2
votes
1
answer
1k
views
How to Publish Checked-In changes only in Team Foundation Server 2013 to SQL Server?
I would like to ask you how to publish checked-in changes only in Team Foundation Server 2013 to SQL Server? It's a new installation of TFS 2013 - installed by me.
Currently when I create new object ...
2
votes
2
answers
11k
views
Data Flow Transform Not Automatically Mapping Columns
I'm in the midst of creating a set of SSIS 2014 packages (using Visual Studio 2013) importing data from 50 tables. Since most of the tables are being filtered on the same column and I'm importing all ...
- 1,933
3
votes
1
answer
2k
views
How to manage stored procedure dependencies in SSDT?
I have multiple stored procedures, some that depend upon others. When publishing my database, I receive an error when creating some stored procedures due to dependency issues. SSDT seems to be ...
- 133
5
votes
4
answers
17k
views
Script component source won't load when click "Edit Script..."
I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but ...
- 311
31
votes
2
answers
25k
views
Why is :r SQLCMD command marked as wrong in Post Deployment Script?
I have worked a couple of times with post deployment scripts and always, intuitively used the build action "PostDeploy", because that is what it is.
Now for the first time I try to follow the built-in ...
- 4,757
1
vote
1
answer
4k
views
The application is not installed - Visual Studio 2013
I need to deploy packages using visual studio 2013 but I am seen this message, the application is not installed, as you can see on the picture below.
what do I need to install?
- 15.8k
2
votes
1
answer
569
views
Migrating Oracle 9i database to MySql database on a different Windows Server
I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have ...
- 121
2
votes
0
answers
829
views
SSDT sqlpackage.exe CreateNewDatabase Parameter Not Respected
Originally asked this on SO but that question seems to be populated only by tumbleweed so wondered if this might be a better forum for it.
I have a VS2103 solution which includes a database project ...
- 441
1
vote
0
answers
203
views
TDE state is changed after DB deployment
I have database projects in Visual Studio 2013 from which I deploying databases to SQL Server. Also I am using Transparent Data Encryption for these databases and it is in state 3 which means TDE is ...
- 111
2
votes
1
answer
1k
views
Prevent Subscription to report from running on a holiday
I have a SQL Server that I am using for building and distributing reports. I have built all the packages for importing data as needed as SSIS packages. These reports only need to be run after the ...
- 155
1
vote
1
answer
743
views
Cannot login to SQL Server from Visual Studio, same credentials work on SSRS page
I am running into a strange issue. I have a SQL Server login that I use for running reports on SSRS. When I go to the SSRS page I can modify the stored credentials to use that login:
Now when I try ...
- 155
2
votes
1
answer
2k
views
How To Merge Database Projects on Visual Studio 2013
Can I have multiple database projects to the same SQL Server database? Like, one main project referencing multiple subprojects.
I have an application with multiple modules and each module has its own ...
- 123
2
votes
1
answer
125
views
How to cope with SQL Server 2012 vs SQL (Azure) Database sql files
I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside.
Given that a ...
- 221
9
votes
1
answer
7k
views
Reference assembly in sqlproj not being deployed to server
I have a Visual Studio 2013 Database Project which takes a modified version of fastJSON as a reference. I selected Generate DDL in the reference properties as shown in this screenshot:
And in the ....
- 2,677
2
votes
1
answer
777
views
Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
I have a SQLCLR stored procedure with the following signature in Visual Studio 2013:
[SqlFunction(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read)]
public static ...
- 2,677