Skip to main content

All 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 ...
Srikanth CHindam's user avatar
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
TimeToCode's user avatar
  • 1,778
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 ...
magicalKhachapuri's user avatar
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 ...
PKirby's user avatar
  • 869
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....
fdkgfosfskjdlsjdlkfsf's user avatar
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 ...
EzzEldin A.Kadry's user avatar
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 ...
lardymonkey's user avatar
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 ...
Yahfoufi's user avatar
  • 2,466
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 ...
Manjunath's user avatar
  • 371
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....
karthik's user avatar
  • 101
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 ...
F.Dn's user avatar
  • 1
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. ...
Maki's user avatar
  • 211
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 ...
droptable007's user avatar
-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 ...
shawn's user avatar
  • 113
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 = ...
user avatar

15 30 50 per page
1
2 3 4 5
29