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

The connection either timed out or was lost- Error while cube synchronization from source server to destination

I am executing XMLA script via scheduled SSIS dtsx package to synchronize the ssas cube form source to destination server. Everytime it works fine but sometimes it gives error in random manner like once in 2-3 months. Error is : "The connection…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
2
votes
0 answers

SSIS package - Completed 100% with an error

We are beginner of SSIS package. Now we trying to create the SSIS package which has Dynamic Source file name and MSSQL table as destination in Bulk Insert Task control flow. *.csv file: policyID statecode county eq_site_limit …
Pugal
  • 539
  • 5
  • 20
2
votes
0 answers

Update the Connection Timeout Property in all the SSIS Packages

We have around 600 SSIS packages running in our production Server. We need to update the Connection timeout property of one of the connection managers ( We to need update connection timeout from 0 to 30 seconds). This connection manager has been…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
2
votes
1 answer

SSIS Variable- Evaluating Expression Taking Time in Script Task

I have a Variable which uses another variable to get its value. I had set the EvaluateAsExpression property to True. Now when I use this variable in a Script task it is taking 2-3 Minutes to evaluate that expression. But if I Hard Code the variable…
Srikar mogaliraju
  • 215
  • 1
  • 10
2
votes
2 answers

How to check if SSAS Partitions are running in parallel or not using SQL Profiler?

I am situation where I have to check and confirm whether SSAS partitions queries are running parallel or not while processing the SSAS cube using SSIS job. SSIS job/package using 'Analysis Services Processing Task' to process cube by selecting each…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
2
votes
0 answers

The server response was: 4.7.0 Temporary server error in SSIS

I am getting an error when I schedule a SSIS package in SQL server job but if run manually the package as well as job also executing successfully. Even if I am creating the package in same server where data present in the database. But when it is…
katraj
  • 381
  • 1
  • 8
2
votes
1 answer

SSIS Package file in Notepad (.dtsx xml version)

I have a huge list of SSIS package, I wanted to know if any of the packages use the default path for the bufferTempStoragePath parameter. To do this quickly, I wanted to make a notepad search with this parameter and that's where I discovered that…
user5963780
2
votes
2 answers

How to upload files to one drive using ssis?

I am looking for a way to upload files to One Drive using SSIS. I've researched and there are some third party tools like CozyRoc, KingswaySoft which provide one drive connection manager. Anyone out there who already have experience doing this? If…
A Chow
  • 61
  • 2
  • 6
2
votes
2 answers

SQL Server Data Tools not available after installed

I'm using Visual Studio 2013, SQL Server 2014. I want to learn MSBI, so I have installed the SQL Server Data Tools from here: https://msdn.microsoft.com/en-us/mt429392.aspx After the installation process, I coudn't find the SSDT from the start…
DineshDB
  • 5,998
  • 7
  • 33
  • 49
2
votes
1 answer

MDX - Same day of Week Last year

Facing some trouble when comes to MDX, trying to get the Revenue PY. Had a date dimension set up with a Year Week Date Hierarchy when I run the below MDX, it is pointing me to 5th Sep, instead of 12th Sep. SELECT ParallelPeriod ( …
Harsha
  • 113
  • 9
2
votes
3 answers

Columns are not defined for this connection manager

When I open my flat file connection manager, I see a warning message: Columns are not defined for this connection manager How do I solve this issue, or is it even something I need to worry about?
nitesh
  • 41
  • 1
  • 1
  • 3
2
votes
0 answers

Flat File Connection Manager, other tool windows font size is too small

A few of the tool windows in VS are showing font sizes that are really odd, wuch as the Flat File Connection Manager and the package progress window. Is there any way to fix this?
kaushik reddy
  • 29
  • 2
2
votes
1 answer

ForEach Enumerator has failed with error 0x80131509 "(null)"

SSIS ForEachLoop Error I am trying to load multiple excel files with multiple sheets but after deploy into server only i am getting this error. The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs…
AJIT
  • 21
  • 1
  • 3
2
votes
2 answers

Failed to deploy project. For more information, query the operation_messages view for the operation identifier '4'

I am using sql server 2012 and in it i have sql server data tools which is using visual studio 2010 so, i have one table which contains name only and i would like to copy this table in destination table so i have taken oledb source and oledb…
sandhiya
  • 133
  • 2
  • 3
  • 17
2
votes
1 answer

SSIS - OLEDB sql table source conversion error - handle

I have a OLEDB source with sql query. i am writing code to fetch data from a table. Also it has some conversions (varchar to datetime). When random data comes like 99999999, its not able to convert the value to datetime and it fails. Is it possible…
Gaurav Jain
  • 21
  • 1
1
2
3
…
20 21