Stack Overflow
Stack Overflow

Questions tagged [bids]

Business Intelligence Development Studio (BIDS) is a special version of Visual Studio that is used to develop projects for SSIS, SSAS, and SSRS.

The Business Intelligence Development Studio (BIDS) is a tool that Microsoft has released to create projects surrounding the Microsoft SQL Server tools. These tools include the Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS). Developers use the Visual Studio development platform to create these projects. Each SQL Server tool comes with an installation of Visual Studio (BIDS). You cannot get BIDS without having at least a developer copy of one of the Microsoft SQL Server tools.

For more about BIDS and its role in developing projects for SQL Server tools, go here:

http://msdn.microsoft.com/en-us/library/ms173767.aspx

736 questions
0
votes
1 answer

Converting All CapsText on a SSRS report to Title Case Text

How to convert Text on a SSRS report to Title Case. Right now I am using =Strconv(Fields!Title.Value, 3) Which works but in some cases eg.: GEORGIA(GA) is the text coming from DB its converting it to Georgia(Ga). I want it convert like Georgia(GA).…
R Kumar
  • 137
  • 2
  • 6
0
votes
1 answer

SSIS Create table with INTO

I would like to auto create a table using BIDS. How would I go about auto-making a new table when the data structure is unknown? example in SQL I would do: SELECT * INTO FROM However, I get the data set. Transform it and…
Michael Kagarise
  • 21
  • 5
0
votes
1 answer

Custom interval expression for the Vertical Axis Major Tick Marks in SSRS 2008 R2

I am creating a chart in my Business Intelligence Development Studio for SSRS 2008 R2. I am having an issue with the Vertical Axis Major Tick Marks. When left on Auto, it sets the Major Tick Marks at every 2 million. I am wanting them every 1…
Code Maverick
  • 20,171
  • 12
  • 62
  • 114
0
votes
0 answers

How to get value from one textbox to another

I have two table being populated by different queries accurately. Say: TableA Col1 Col2 Col3 Col4 Val Val TblBColAVal Val TableB ColA Val I want to get the value in textbox TableB ColA to textbox in TableA Col3. I have tried…
GPGVM
  • 5,515
  • 10
  • 56
  • 97
0
votes
1 answer

Cannot convert to numeric data type (SSIS)

Unfortunately nobody really has much knowledge about this source database, so while I was told that the incoming data was a FLOAT, it is appearing like that is not the case. I have an incoming field with some sort of numeric datatype, and its value…
Goose
  • 3,241
  • 4
  • 25
  • 37
0
votes
1 answer

Generate schema for a analysis services database project

I was given a task to have a better understanding of several ETL packages that were created in a Database project using Business Intelligence Development Studio(SQL 2005). Currently I have to open each master package, package and then data flow and…
rjso
  • 1,314
  • 10
  • 19
0
votes
0 answers

Grouping by Year/Month in RDLC Report

I'm trying to group by report by Year, then Month. My data is like so: ID | Date | Value 1 | Value 2 1 | 1/1/13 | 200 | 300 2 | 1/2/13 | 300 | 400 On my RDLC report, i've managed to group by Month using…
user2401849
  • 67
  • 5
0
votes
2 answers

Issue regarding SSAS features while trying to process a cube in BIDS

I recently adventured into BI and am currently trying to process a cube onto the ssas (by using a BIDS SASS project). I originally had the SQL 20008 R2 Standard version and therefore got the following error: "Errors related to feature availability…
J_Ocampo
  • 445
  • 1
  • 7
  • 18
0
votes
1 answer

Include Shared Data Source on report?

I am new to using BIDS and to developing reports in general and I am currently working to add a new report to an existing solution. My report needs to make sure of a shared data source in the solution so I was just thinking I should copy over the…
Jfabs
  • 543
  • 4
  • 9
  • 23
0
votes
1 answer

Adding styles to Parameters controls in SSRS 2008

I am new to SSRS. We are building reports in BIDS 2008 and hosting them on Share point. There are different parameters for these reports like Regions/Districts, Start Date and End Date, Which by default shown as Dropdowns and Calendar controls by…
R Kumar
  • 137
  • 2
  • 6
0
votes
1 answer

SSIS Job did not run properly

I have built a SSIS package to EXEC a SP in SQL 2008. When Run the package from BIDS, it generates all the results which insert into a table (took about 1 min). But when I scheduled to run as an Agent Job in SQL then it took only 2-3 sec with no…
tkvo
  • 171
  • 5
  • 15
0
votes
0 answers

SSIS Data Source Name Change

I have about 30 SSIS jobs in a solution, and they all use a common data source which is named ProjectDBDev, but I want to change this to be ProjectDB, dropping the DEV part. I didn't want to blindly do this and find I need to alter the references…
Christian Phillips
  • 18,399
  • 8
  • 53
  • 82
0
votes
1 answer

Install BIDS 2008 with SQL Server 2012 Environment

I have installed VS2012 and SqlServer2012 in my machine. I have installed sql server data tools 2012 in other to enable BI project in my VS environment. Now, I'm having a project which the project requirement is using BIDS 2008. The question is…
pegasustech
  • 67
  • 4
  • 13
0
votes
1 answer

Empty cell values in column after publishing report

I have a report in SSRS (BIDS) that shows seven different columns. First one shows name. The other shows some data in number/currency format. All data comes from same dataset. All data shows when viewing in preview. Then i publish and try so show…
daniel_aren
  • 1,714
  • 3
  • 24
  • 41
0
votes
0 answers

Capture SSIS runtime variables

I have an SSIS package with several variables in the User:: namespace. I am hopeless pathetic in C# programming. I would like to gather (loop through) each variable and its value to be used in a For Each container that will use an SQL Task to write…
DarkRiver
  • 423
  • 2
  • 5
  • 7
1 2 3
…
49 50