84 questions
0
votes
0
answers
16
views
How to reverse the SSIS Data Flow?
Currently I have on SSIS package which reads the fixed length string and dump in to SQL-Server Tables.
Current Flow:
[Flat File Read Task] --> [Multicast] --> [Insert Multiple Tables].
Desired ...
- 99
1
vote
1
answer
4k
views
Local window shows empty Variables while debugging SSIS package in VS Data tools 2012
This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty.
SS of Locals window showing blank value ...
- 1,541
0
votes
1
answer
102
views
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 ...
- 119
0
votes
1
answer
549
views
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 ...
user7951164
0
votes
1
answer
2k
views
No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found
I migrated a schema of DB2 v9.1.700.855 to SQL Server 2012 using the tool "SSMA (Microsoft SQL server migration Assistant) for DB2", I can establish a connection, but it shows an error :"Error ...
0
votes
1
answer
700
views
Add a Scroll box in SSRS
I've searched the all Internet and didn't come up with a solution.
well, I have a report for a client which I made it in ssrs.
The report basically display :
Col1 Col2
Num Num
I want to add a ...
- 488
0
votes
1
answer
788
views
How to Overwrite Database Table Data Using SQL Server Data Tools
I'm currently working on a small project using sql data tools. I'm getting data from excel sheet and write it back to my database table. from the database table I'm generating a report. Time to time I'...
- 63
3
votes
1
answer
21k
views
SSRS - How to add a default value to a parameter with Available Values from a query?
I have an SSRS report which contains a parameter ID, which will display sales totals for a person with selected ID. I get the options for the parameter by selecting "Get values from a query" under the ...
- 3,517
26
votes
7
answers
85k
views
The report definition has an invalid target namespace rsInvalidReportDefinition
I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the report wizard, the rdl file has schema for 2016. My reporting server is of version 12.0....
- 2,072
0
votes
1
answer
2k
views
Compare dataset with another dataset for multiple Columns/Values SSRS
This is the image reference. Let me explain the scenario.
There are two datasets A and B as you can see, dataset B has actual tests values and dataset A has target values (more like ranges). code ...
-1
votes
1
answer
248
views
SSIS environments and deployment
I use SQL Server 2012 with Visual studio 2010 with Integration Services Catalog. I would like to know if it is possible to deploy my ssis 2012 project to only one of the three environments I have ...
- 11
0
votes
0
answers
107
views
How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)? [duplicate]
How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)?
Create Table ProspectiveTenant
(
PTID int,
Name varchar (25),
Email varchar (25),
...
- 1
0
votes
2
answers
4k
views
SSAS Process Dimensions Error
I'm trying to deploy my SSAS project but I keep getting this error that makes no sense to me?
Error 5 Internal error: The operation terminated unsuccessfully. 0 0
Error 6 The ...
- 717
-1
votes
1
answer
2k
views
SSIS error connecting to Excel Source
I have a 64 bit machine.
One of my projects I have the properties of the project for Run64BitRunTime = False and I still get the following error when attaching to an Excel xlsx source in order to ...
- 241
2
votes
1
answer
435
views
(SQL Server Analysis Services) MDX query to get immediate parent?
Desired result
When a cube is deployed and browsed, I wish to see only an immediate manager of an employee.
The cube result shows all managers of a paticular employee, like below:
Abbas, Sanchez, ...
user4296898
1
vote
1
answer
915
views
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
- 11
0
votes
1
answer
623
views
SQL SSAS Cube Deploy Error:
I am trying to deploy a cube I created in SQL Server Data Tool using AdventureWorksDW2008R2, I used windows authentication login the database engine with all permissions granted to it. and yet I ...
- 172
0
votes
1
answer
119
views
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 ...
- 1,467
2
votes
1
answer
917
views
How to add an extra column to handle error message in a SSIS data flow?
I'm working on a SSIS project in order to import calls rows (Excel file) in a SQL Server database.
Here is my data flow :
I added some lookups to check rows before import process.
The first one ...
- 741
0
votes
0
answers
417
views
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 ...
- 145
8
votes
2
answers
4k
views
Trigger is blocking database project publish
I have a Visual Studio 2012 database project, containing my database schema. In a post deployment script, I automatically create a number of triggers responsible for logging changes to the table's ...
- 8,276
0
votes
1
answer
231
views
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 ...
- 253
0
votes
1
answer
174
views
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 ...
- 253
0
votes
2
answers
934
views
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.
- 27
5
votes
1
answer
3k
views
SSDT - Ignoring partition function changes
I'm trying to publish a database project, which also contains a partition function.
My destination databases have different (date) values which I do not wish to modify, although SSDT/SqlPackage always ...
- 151