Stack Overflow
Stack Overflow

Questions tagged [msbi]

MSBI (Microsoft Business Intelligence) is a suite of tools providing solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server.

MSBI stands for Microsoft Business Intelligence. This suite is composed of tools which helps in providing best solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server. It empower users to gain access to accurate, up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

MSBI is divided into 3 categories:-

SSIS – SQL Server Integration Services. SSAS – SQL Server Analytical Services. SSRS – SQL Server Reporting Services.

Source: http://www.phpring.com/what-is-msbi-microsoft-business-intelligence/

309 questions
2
votes
0 answers

how to get only column names from XML datasource in ssrs

I have a requirement to consume and display records from webservice in ssrs. From webserice I am able to access and display the records when I was returned as list. but I would like to return the dataset from webservice and consume the columns in…
user2681423
  • 21
  • 6
2
votes
0 answers

automating setting ssis parameters for multiple projects in ssis

I have SSISDB with 1000 projects in SSIS 2012,i have migrated this SSISDB to other server can anyone help me how to update the parameter values server name present in SSISDB to new servers
user2152162
  • 21
  • 1
2
votes
2 answers

Dynamically executing multiple packages using execute package task in SSIS

I'm trying to execute several packages dynamically. I've a table in database that stores the package names and has an indicator for each as 'Y/N'. My ultimate objective is to execute those with indicator 'Y'. I'm creating a variable that takes all…
Ayushman Basu
  • 53
  • 2
  • 8
2
votes
1 answer

how to check the value in SSRS automatically based on other parameter values?

I want the parameter value to be checked automatically in the second dropdown based on the selection of first parameter value. For e.g In the below image i am selecting the Finops in the first dropdown so in second dropdown it should checked…
Rajashri
  • 59
  • 1
  • 5
2
votes
1 answer

How to send ONLY one mail from OnError event handler in SSIS

I have a package which contains several contains and tasks in it.I have used Send Mail task in Error Event handler to send mail if any error occurs during the load. But whenever error occurs in package, Send Mail task has been executing twice or…
Ram Das
  • 348
  • 4
  • 15
1
vote
0 answers

SSIS - Error ORA - 28040 No matching authentication

I have developed SSIS package that connects to Oracle 12c. This package fails on my local machine but runs perfectly fine on our server. The Oracle source is 12c and it's on a different server. My local machine and my server (where the package runs…
LearningPy
  • 11
  • 1
1
vote
1 answer

How to Clear SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED?

I got this error message after running my SSIS package. Source : flat text file Target : sql database Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised…
sampath acharya
  • 133
  • 1
  • 3
  • 14
1
vote
1 answer

Download SFTP file using SSIS package

I want to create a SSIS package which need to download a file automatically and place it in our local. Note: using process executive task and batch script files only.
Kalwala Yashwanth Kumar
  • 11
  • 2
1
vote
1 answer

How to remove multiple characters between 2 special characters in a column in SSIS expression

I want to remove the multiple characters starting from '@' till the ';' in derived column expression in SSIS. For example, my input column values are, and want the output as, Note: Length after '@' is not fixed. Already tried in SQL but want to do…
user3620085
  • 99
  • 1
  • 3
1
vote
1 answer

SSIS Data Conversion task is giving wrong output when source datatype is BIT

I have created two tables from below script: CREATE TABLE Test (ISDELETED BIT) CREATE TABLE Test1 (ISDELETED INT) Table Test data: Here datatype of column isdeleted in table test is BIT and in table test1 datatype is INT. So now using SSIS I am…
Anagha
  • 918
  • 1
  • 8
  • 17
1
vote
0 answers

SSIS Project setup

I'm a beginner with the microsoft bi stack - including SSIS. My tests confirm that it is a very good tool. What I couldn't find out on the fly, however, is whether and how projects can be handled in a team. Is it possible for 2 or more people to…
phpler
  • 9
  • 3
1
vote
2 answers

Sales Person (Regional Manager, Zonal manager, Country Head) linking to Fact table

I have a small data warehouse for Sales. Here i have Fact Table for Sales Invoices and Dimensions like customer, Date Time, Sales Geo, Product Code. Fact Table: Sales - > Invoice Date, Customer code, Product Code, Sales Geo Code, Billing qty,…
Casabi
  • 11
  • 1
1
vote
1 answer

MDX iif condition only on not empty cells

How do I combine and iif condition with the fact that it should only be valid for cells with values? Concretely I have a column where I identify the difference between column A and B. Now I want to define a threshold and show a YES or a NO whenever…
user14359940
  • 11
  • 1
1
vote
1 answer

MSBI ISPAC file does not execute on double click

I have VS 2017 SSDT 2017 and SQL Server 2017 . I have created the ISPAC setup of SSIS but when i double click on the setup file it does not execute and prompts me asking how to open the same. I was watching the training videos of Questpond of MSBI…
Himal Ayan
  • 13
  • 2
1
vote
1 answer

SSAS named set with hard codded members

I am trying to create a common named set with fixed members so it can be used in multiple calculated members. But for some reason, it's failing. I am new to MDX scripting. Let me know if there is an issue here. Aggregate({[TT Collection].[TT…
Arjun
  • 1,049
  • 6
  • 23
  • 37
1 2
3
…
20 21