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.
Questions tagged [sql-server-2012-datatools]
84 questions
0
votes
1 answer
Relative KPI value
Im working with MS Analytics Tools. I would like to create a KPI showing monthly change of number of sold products. I have my measure [Measures].[Sold Count] and dimension [Date].
Moreover the goal should be "increased by 1.5% in selected month".
My…
Krever
- 1,371
- 1
- 13
- 32
0
votes
0 answers
How do I calculate the sum of population of a group of city in MDX?
I need to create a Calculation in the SQL Server Data Tools.
Imagine that in my OLAP structure I have a City and a Seller Dimensions, and a fact. And in the City Dimension I have a city, a state, and a Population, and this is a Measure in a…
Lucas Motta
- 135
- 2
- 11
0
votes
1 answer
Sorting Column in SSRS by Background Color
Is it possible to sort a column in SSRS by background color? For example, if I have an expression that will make the cell either RED or GREEN, is there a way to have all the columns with RED background cell colour sorted before listing cells which…
choloboy
- 795
- 4
- 16
- 38
0
votes
1 answer
SSIS FOR Loop going into infinite loop
I believe I have set the expressions right, but it keeps going into infinite loop. Here are the details:
Variables:
@CD Datetime = @[User::ED]
@ED datetime = 3/31/2014
@M12 Datetime = DATEADD("d", 1, DATEADD("m", -12, @[User::ED]…
Meta747
- 253
- 1
- 16
0
votes
1 answer
SSIS Derived Column Expression from SQL code CASE..WHEN
I have been trying to convert the following SQL code with CASE--WHEN to SSIS Derived Column expression. The expression would go in a new column with varchar(5) datatype.
The SQL Code:
CASE
WHEN SUBSTRING(A.Column1,1,5) = 'John'
OR
…
Meta747
- 253
- 1
- 16
0
votes
1 answer
SSRS not using default parameter values
I have a report in which I did everything the same (with respect to parameters) as I always do, but for some reason when I preview the report in Data Tools, default values for SystemName parameter isnt used.
Here is a screenshot:
Default and…
choloboy
- 795
- 4
- 16
- 38
0
votes
1 answer
Design dataflow that accounts for AND clause in Left Outer Join
I have a query that I am putting through SSIS merge join (left join). It joins only on the columns specified in the ON. What do I do for it to consider other columns with AND?
SELECT Col1, Col2
FROM Table1
... many joins..
LEFT JOIN Table5 T5 ON…
Meta747
- 253
- 1
- 16
0
votes
1 answer
Calculate Value For Dates Between
A few references:
Microsoft's documentation on DATESBETWEEN.
Somewhat similar question, though the answer and derivatives of the formula don't return the correct results.
Microsoft's documentation on TODAY
Per the above Microsoft documentation,…
user3730569
- 15
- 1
- 4
0
votes
2 answers
Integrate an SSRS with a C# app
I have a SSRS solution with a report and I'd like to integrate that report with an C# app that is in another solution. Could anybody you tell me how can I do that?, I'm using visual studio 2010.
David Acosta
- 27
- 1
- 1
- 5
0
votes
1 answer
VS cant browse SSAS cube
When I try to browse a cube in VS2012 it will crash my VS instance even though it deployed perfectly fine. I have tried different combinations of uninstalling and re-installing software. I am wondering what could possibly be missing.
I have…
Goku
- 1,565
- 1
- 29
- 62
0
votes
1 answer
SSIS and Informatica
SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additional fetures are there in the Informatica new version than…
user1254579
- 3,901
- 21
- 65
- 104
0
votes
1 answer
SQL Server Data Tools 2012 - deployment package for multiple databases
In our company we have database solution that contains three SQL Server instances each with different databases. Each instance has some jobs and replication.
As for now we are maintaining creation and update scripts manually and execute them with…
scar80
- 1,642
- 2
- 18
- 36
0
votes
1 answer
SQL Server Reporting Services in SQL Server 2008 R2
I have existing installation of SQL Server 2008 R2. I need to add SQL Server Reporting Services. When I install the feature then I select 2nd option which shows to add feature in existing installation when I select second option
when I install it…
user2931015
- 219
- 2
- 8
- 21
0
votes
0 answers
SSDT and vs2010: Can I work on database projects without importing?
Whenever I Import I find lots of errors that since the database hasn't been worked with this tool, we did not have to fight case sensitive issues, nor views with unreferenced tables and a lot of other stuff that didn't worry us when we were on…
apacay
- 1,702
- 5
- 19
- 41
0
votes
0 answers
Connection cannot be made to redirector
I am trying to deploy my first SSAS project. The Sql server is on a remote machine. I'm able to RDP and ping the machine.
I have restarted the SQL Browser service
sql browser has been started with admin account
I've turned off the firewall
I have…
Alex Gordon
- 57,446
- 287
- 670
- 1,062