All Questions
Tagged with visual-studio-2013 sql-server
425
questions
0
votes
0
answers
175
views
Couldn't able to establish SSIS connection manager with Citrix home page's Visual studio but able to execute SSRS report with run option
We have Visual studio application in Citrix home page which is not able to establish SSIS connection manager, but it is able to execute SSRS report with run option and an error preventing SSRS preview ...
0
votes
0
answers
63
views
unable to add connection Visual studio 2013
I am trying to add a connection in my VS 2013 file. I have SQL Server 2016 and visual studio 2013 but when I try to add a new connection in VS file this shows me an error
any solution, please
0
votes
0
answers
88
views
Integration services deployment straight to SQL Server
I have a custom Integration Services script which produces an ispac file for me. I want to deploy this ispac to SQL Server with SSMS, but I get an error, it's deployed but packages can't be executed ...
0
votes
0
answers
116
views
VS 2013 Shell (Integrated) SSIS project incompatible
I am unable to view my SSIS projects in VS 2013.
If I try and reload the project, I get an 'Unsupported - This version of Visual Studio is unable to open the following projects'
The project worked ...
1
vote
1
answer
566
views
Primary key not a Measure in cube?
I'm new to SSAS, so please bear with me.
I have two tables: FactTest and DimLocation. I'm including the table schema, but in essence, and FactTest.LocationName is foreign key to DimLocation....
3
votes
0
answers
724
views
How to find SQL Server database files in application files when the project is published in VS 2013?
I'm trying to make a setup for my Visual Studio 2013 project and I'm using SQL Server database connected to it.
I'm trying to publish it with the normal way but when I'm checking the applications ...
1
vote
1
answer
3k
views
How to update the Entity Framework auto-generated code for the results of a stored procedure
What I am trying to achieve is to get the auto-generated code to update for the results of a stored procedure.
What I have done so far is:
Modified the stored procedures in my development database
...
1
vote
2
answers
507
views
Balanced Data Distributor Installation Error
I am working with SQL Server 2014 SP3 x64 and i have installed the cumulative update 1.
I have installed Visual Studio 2013 Professional and SQL Server Data Tools - Business Intelligence for Visual ...
0
votes
2
answers
662
views
Create scripts from DB project using Visual Studio 2013
I have a requirement where in I need to create seperate script files for procedures, functions and views when we generate the build . We follow the method where we drop all the objects and then re ...
0
votes
0
answers
109
views
Getting error while connecting VS2013 with SQL Server 2016
I'm getting the below error while trying to connect and get the data to Visual webpart (VS 2013) from SQL Server 2016:
An exception of type 'System.Data.SqlClient.SqlException' occurred in System....
0
votes
5
answers
968
views
Cannot implicitly convert type 'string' to 'int' errors
I want to save the information entered in ASP.NET to the database and display it in GridView but the information that needs to be entered is dropdownlist selected.
The IDs of the elections held are ...
1
vote
0
answers
331
views
InterSystems Cache Database and SSMS Integration Services Catalogs
I am trying to built a SSIS package thru BIDS VS 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014.
As a Sanity check. ...
1
vote
2
answers
939
views
SSRS email subscription sending the old version of the report
I have a ssrs report with email subscription which excel attachment every morning to a list of email addresses. The report is sending 2 emails everyday now after i updated the report and redeployed it ...
-3
votes
1
answer
2k
views
Upgrading Database .mdf File Visual 2013 to 2017 SQL Compatible Connection Error?
The Data Source value in the connection string specifies an instance of SQL Server that is not installed. To resolve this issue, you can either choose to install the matching instance of SQL Server or ...
0
votes
1
answer
51
views
How to save a string in SQL Server as SqlDateType by using Visual Studio 2013?
How to save a string in SQL Server as SqlDateType by using Visual Studio 2013? My string which I want to save is 1996-25-04. I am working with C#.
I have tried this as far
SqlConnection con = ...