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
0
votes
2 answers

SSIS ForEachLoop editor for Excel files with any extension

Task: I'm trying to iterate through excel files using foreachloop editor container. I was successful until i had different extensions meaning it's works as long as file extension is xls or xlsx but not both together. Problem: I get errors when i try…
user1810575
  • 823
  • 3
  • 24
  • 45
0
votes
2 answers

ForEachloop SSIS

Task: Loop thru these excel files and insert data into SQL table but in the process i get an error and i don't know which it errored on. My understanding is SSIS doesn't loop thru file in an random order but i get an error about CANNOT ACQUIRE…
user1810575
  • 823
  • 3
  • 24
  • 45
0
votes
3 answers

How to repeat Header of an ssrs report?

I have a problem with particular report. I have created as simple matrix report in SSRS which user will download in excel format. I have set header repeat property for the matrix, but when I download the report and check report in print preview, it…
Dilip Chauhan
  • 124
  • 5
0
votes
1 answer

Send mail task failure with error due to SMTP Connection

I've created an SSIS package which runs perfect when scheduled as a job.Now I've have a requirement that a mail ought to be sent every time it runs stating if the package was successfully completed or failed. I've created an SMTP Connection with…
VJAI
  • 111
  • 1
  • 14
0
votes
1 answer

Align images dynamically alongside bar graphs in SSRS Charts

My requirement is to display images dynamically next to the bars in SSRS charts. I have been using many ways and was not able to find an apt solution to the problem. I have used the bar graphs and a tablix to display images next to the bars. I have…
chaitanya.moguluri
  • 240
  • 2
  • 8
0
votes
1 answer

How can I deploy SSRS reports to report server without debugging report?

How can I deploy rdl files with SSDT solution without debugging rdl file, so that I can avoid the data set or data source error. Its a kind of a rdl files migration, without using any rs.exe kind of utility. Its working so far, but each time I have…
Aditya
  • 2,299
  • 5
  • 32
  • 54
0
votes
2 answers

Microstrategy vs SSAS

A sample Dimension table structure is given below for reference. CREATE TABLE [dbo].[DimDoctor] ( [skDoctorKey] [int] IDENTITY(1,1) NOT NULL, [DocCode] [char](9) NOT NULL, [FirstName] [varchar](30) NULL, [lastName] [varchar](30)…
Jithin Shaji
  • 5,893
  • 5
  • 25
  • 47
0
votes
2 answers

How can we use file as the format in the Flat file Connection manager?

I have to import data from flat file to the SQL server table. The flat file location and the database of the table can differ but the table name is same across all databases. The table can differ slightly in terms of columns, so the flat file too.…
azim
  • 575
  • 4
  • 11
0
votes
2 answers

Executing the multiple instances of same package simultaneously through application?

I have a SSIS package which is executed from application. Can the same package be called simultaneously?
azim
  • 575
  • 4
  • 11
0
votes
1 answer

SSIS Row Count Variable information in a Email Script Task

I am trying to get the Row count variable information which is there in a Data flow task to the Script task in the same package with no luck. I have given the row count as an integer and declared at the package level so that i can call in the Script…
IAmHomes
  • 513
  • 2
  • 11
  • 20
-1
votes
3 answers

Rewrite a sql query for better optimization

I have a table that has the following data id orderid 1 0 1 1 1 2 2 0 3 0 3 1 An id can have multiple order ids. If an id has only a single row with orderid 0 then it indicates that the order is not placed yet. I have find all…
joemac12
  • 113
  • 1
  • 7
-1
votes
1 answer

Using Merge statement in SQL server

Using Merge in sql server i need load only 1 year data from the source table. Please help me to built the logic. DATEADD(year,-1,getdate()) -- one year date MERGE target_table USING source_table ON merge_condition WHEN MATCHED THEN…
preetham.k.m Gowda
  • 1
-1
votes
1 answer

Dax to find previous day sale based on data availability

I have created one measure in SSAS tabular called "Yesterday Sales by using max(date)-1", with this I am getting blanks if data is not present for max(date)-1. how to get the sales for the next available date. for Example, my max(date) is 2019-11-25…
sumantth pendemssai
  • 1
  • 4
-1
votes
1 answer

Create ETL JOB using SSIS for the process

Below is my ask. I have a column A in source table that has value 0 and 1. I have created a derived table for that column and associated column B, and have destination table where there is already associated column which has value "XYZ" where…
asd
  • 1
-1
votes
2 answers

Newtonsoft.json dll issue in ssis

Can anybody help to resolve this. I have added third party reference (Json newtonsoft) dll in my script component, but when i run the package through sql server agent, I am getting an error Could not load file or assembly 'Newtonsoft.Json,…
Jai A
  • 1
1 2 3
…
20 21