Questions tagged [sql-server-2012-datatools]

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.

84 questions
1
vote
1 answer

Connecting Multidimensional Cube to PowerView

i am new to SSAS . we can connect tabular model in SSAS to powerview . Can we connect Multidimensional Cube(Datatools) also to Powerview without sharepoint Thanks
1
vote
1 answer

Unable to preview report - error occurred during report processing

I am getting the following error when trying to preview an RDL report. I have full rights to the SQL SERVER I have tested my connection to the datasource and it's fine I have full rights to the reporting services (serverName/reports) My…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
1
vote
1 answer

SSRS Report with SQL

So I have a report that I'm trying to create for my class. I'm using the AdventureWorks database so it isn't anything to complex. I enter my SQL script in SQL Server Management Studio and HeidiSQL and both bring back the results I'm looking for, so…
1
vote
1 answer

How should I handle users in database projects?

We have two environments - a dev environment and a production environment. We have a different group of users in the development environment than the production environment, but there doesn't seem to be a good way to represent this in the database…
Jeff
  • 12,555
  • 5
  • 33
  • 60
1
vote
3 answers

Using VS2012's SQL Server Data Tools without VIEW DEFINITIONS permission

I am trying to compare two databases using Visual Studio 2012. However, the SQL instance where my database is being hosted is extremely locked down and my user does not have access to the VIEW DEFINITIONS permission. I'm getting these errors in…
1
vote
2 answers

"Expressions" option is not availble for Flat File Connection Mangaer propery

I'm loading a multiple Flat files by adding looping. But i'm not able to see the Expressions option in Property pane for Flat source connection manger in SQL Server data tools. But i'm able to see the expressions options available for "Foreach loop…
Player_Neo
  • 1,413
  • 2
  • 19
  • 28
1
vote
1 answer

How to make a Named Calculation in SSAS return the minimum date while execution

I have built a cube; and am not able to get the right results from it. Here is the issue I am facing. I have a table in the DSV where I added a named calculated column. This column depends on two other columns: Customer ID and date. This calculated…
1
vote
2 answers

MS SSAS 2012 - You can only open files that are compatible with Microsoft SQL Server 2012

I am trying to create a new Analysis Services Tabular Project with SQL Server Data Tools in the VS 2010 shell. As soon as I click ok I get the error that the file cannot be opened. Both the client tools and the server or at 11.0.3000.0. Here are…
1
vote
2 answers

ASCMD for SQL Server 2012

Till now, I used ascmd to execute some queries to SSAS 2008R2. My company begin to install some new SSAS 2012 servers and I want to re-use all my maintenance scripts with these new servers. I can't find any ascmd tool in SQL Server 2012 neither any…
el_grom
  • 163
  • 1
  • 3
  • 15
1
vote
1 answer

Logon Fail Integration Services 2012

I have a SSIS Project deployed in SQL Server. The connection manager in the project are linked to a server name that is not the one where the SSIS project is deployed. After i execute the master package in sql server errors pop ups in the report…
1
vote
1 answer

Trouble opening a SQL 2005 .dtproj file in VS 2012 or VS 2010 data tools

I tried to open this old SQL Server 2005 code example from a book, but the conversion wizard for both VS 2010 or VS 2012 won't conver this .dtproj, it fails every time and there is really no good reason in the conversion log to help. I assume the…
PositiveGuy
  • 46,620
  • 110
  • 305
  • 471
0
votes
0 answers

find out if sql view used from profiler

I am new to sql database, Profiler. I have an application (with no source code access) and it is connected to sql database. There are multiple views and stored procedure. How to find out/filter out if web application is using sql views from sql…
geek
  • 794
  • 3
  • 16
  • 41
0
votes
1 answer

SSIS Deadlock with a Slowly Changing Dimension

I am running an SSIS package that contains many (7) reads from a single flat file uploaded from an external source. There is consistently a deadlock in every environment(Test, Pre-Production, and Production) on one of the data flows that uses a…
tCoe
  • 401
  • 1
  • 5
  • 24
0
votes
1 answer

Unpacking and building SQL Server 2014 project with VS2012 sqlpackage.exe

I've been trying to test whether a project (DB, SSIS, SSAS) built on SQL Server 2014 will be compatible with SQL Server 2012. I've got a .dproj packed in dacpac format and when I try to run this from cmd: sqlpackage.exe /Action:Script…
0
votes
1 answer

Date is not getting inserted into table with defined format

I am inserting some data into a table on different SQL server , for this purpose i have created a dtsx package , We need data in destination table in dd-mm-yyyy format and i am using below query to convert date into desired format …
user7951164