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
1
vote
0 answers

one to many dimensional relation ssas

Need your help or suggestions over my case here in SSAS modeling I am basically struggling with 4 tables, Customer, CustomerPhone, CustomerEmail, CustomerBusinesses. Providing the sample data below, only the dimension Customer is linked to all,…
Harsha
  • 113
  • 9
1
vote
2 answers

SSIS- ADODB Recordset Error

I am getting below error while running my ssis package. Error: COM error object information is available. Source: "ADODB.Recordset" error code: 0x800A0BCD Description: "Either BOF or EOF is True, or the current record has been deleted. Requested…
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
1
vote
1 answer

MSBI: how to create a measure with DAX that implements statistical de-identification?

I need to apply statistical de-identification rules in an MSBI Tabular model. An example of the kinds of rules I'm trying to implement are: if N < 20,000, then any row less than 11 must be combined with other rows. Example: I reports counts of Foo…
tysonwright
  • 1,525
  • 1
  • 9
  • 19
1
vote
2 answers

How to create a dynamic variable to load a field in a table in SQL Server

I'm stuck with a scenario where i have to create a dynamic variable for a select query which hold the data of a particular filed. Here is the scenario Table 'Customer' has below data Column0 Column1 Column2 Column3 Column4…
Meet Rohan
  • 75
  • 2
  • 13
1
vote
2 answers

SQL - Combine rows into single row to retain parent record when duplicate exists

I want to combine records with duplicate into single row. The surviving record will be updated with info from the duplicate if available. In the example below, I want to retain ID 500 then supply the missing data from its duplicate record which is…
SQL Knows
  • 11
  • 4
1
vote
2 answers

How to select a value based on the position from a delimited column in SQL server 2012

I have to write a select query to get the value from a comma delimited column based on the position. When i say position means every value between comma considered as one position. Example: Source table 'alphabets' has one column with value as…
Meet Rohan
  • 75
  • 2
  • 13
1
vote
3 answers

Loading Comma Separated csv file to table in SSIS

I have a csv file with below formatted data. File: Sample.csv Id,Name,Address 1,Abcd,street1,3rdcross,xxxx 2,Cfre,2ndmain,3rdstreet,yyy 3,Asdf,4thmain,1stcross,zzz Need to load the data to table like below. Table: Sample Id Name Address 1 …
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
1
vote
2 answers

Issue loading-data-from-multiple-db-to-another-server-using-ssis

I am facing issue in loading-data-from-multiple-db-to-another-server-using-ssis I have referred the below link Loading data from multiple db to another server using SSIS SSIS Package FLow : Unfortunately i am getting the error in "Execute SQL…
Julie
  • 11
  • 4
1
vote
2 answers

Move files with SSIS to different directories dynamically based on excel file names

How to move multiple excel files to different folders based on file name in ssis? means based on the file name it will move to respective folder.
Ajit Kumar
  • 107
  • 1
  • 6
1
vote
0 answers

Column Name checking using script task in ssis

Source folder contains multiple excel files with same metadata. Our requirement is all excel files should have all the required columns so How check all required columns are present in Excel files or not through Script Task in SSIS?
Ajit Kumar
  • 107
  • 1
  • 6
1
vote
2 answers

Bulk Insert Control Flow Task(SSIS) complete without loading the source file, but no errors too

I try to load a csv file whose content is below, into a SQL Server 2012 database table NYC_Business_Establishment_DataSet using the "Bulk Insert Task" in SSIS 2012 control flow. The control flow task complete without any error, but I cant see this…
Harinath Arasu
  • 145
  • 1
  • 5
  • 12
1
vote
0 answers

Could not load package "\File System\ because of error 0x80070002. Description: Unable to find the specified file. Source: MsDtsSrvr

We are building a new environment having SQL server 2014 and migrating our SSIS job to the new environment. We have a SSIS job named as ABCD (assume) The job is deployed as file system deployment: C:\Program Files\Microsoft SQL…
Faiz Rahman
  • 23
  • 2
  • 8
1
vote
2 answers

how to get the value of side by side in a column in SQL

I have some problem to get the data like if I have a columns in table CDPRCL CDITEM CDSQFT F162_U 18-020-0056 SOUND SYS 1.00 H 18-020-0056 WET BAR 2.00 D as you can see the…
Mukesh
  • 55
  • 4
1
vote
1 answer

How to get the previousID in SSIS using Lookup?

i have two input tables: 1) Site: site_id|| site_name|| site_location 1000 || abc || XYZ_123 1001 || tyu || ERD_123 1002 || iok || FTR_678 1003 || okn || YHU_987 1004 || ybg ||…
Looking_for_answers
  • 343
  • 1
  • 6
  • 20
1
vote
1 answer

Convert datetime formats to a particular format in SSIS

Destination column data should in one format: How to do the HireDate column in one format at destination table of sql server.
Ajit Kumar
  • 65
  • 1
  • 1
  • 3
1 2 3
…
20 21