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

How can I merge rows (of a particular column) having the same value in SQL Server Reports RDL?

I'm new to working with SQL Server 2005 Reporting Servives using RDLs in BIDS. I need to modify an existing report so that I can merge cells in adjacent rows which would have the same value for that particular column. Ex: consider this is the table…
Tx36
  • 506
  • 2
  • 6
  • 7
3
votes
3 answers

SSIS Custom Control Task Debugging UI in BIDS and VS

I've created a SSIS Custom Task in C# and I'm currently developing the UI. I was wondering if there is a better way of debugging the UI instead of compiling the project, copying the DLL's into the appropriate DTS folder and then opening the test…
zeencat
  • 589
  • 1
  • 5
  • 26
3
votes
1 answer

SQL Server BIDS, SSIS aggregate and group by

I have an employee table with an employee_id, name, and working_division, where the employee_id is the primary key. I have an Excel source with these columns and more where an employee has entered their hours, and what type of work they have done,…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
3
votes
7 answers

SSIS Script Editor throws an exception

I have SQL Server 2012, SSIS, SSDT and Visual Studio 2010. I can create a new SSIS package and add a Script Task, but if I attempt to open the Script Editor for that Script Task I get the following error: TITLE: Microsoft Visual…
Raymond Saltrelli
  • 4,071
  • 2
  • 33
  • 52
2
votes
1 answer

Adding multiple rules for indicators SSRS BIDS

I have produced a report which allows you to drill down into the table you see with ticks and crosses. Each tick indicates that a task is complete. In the second picture you can see the rules which dictate whether the task is classes as complete or…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
2
votes
1 answer

Install Business Intelligence studio 2008

I need to work on SSRS and for that I would need BIDS. I have installed SQL Server 2008 R2 Express Edition with Advanced features, also I have VS2008 installed. How can I get BIDS installed on my machine?
pramodtech
  • 6,300
  • 18
  • 72
  • 111
2
votes
2 answers

How to handle an empty query result on a DataFlow Task?

I'm iterating several years with a Dataflow inside a Foreach Loop, but there are some years that will not return any data, therefore they SSIS package fails, is there a way to handle this? To tell the package to ignore those blanks and keep…
user1112251
  • 119
  • 1
  • 4
  • 13
2
votes
2 answers

SSIS XML XSLT Task runs out of memory

I am developing a package in BIDS 2005 that starts with a XML (XSLT) Task against a very large input file and keep getting the following error [XML Task] Error: An error occurred with the following error message: "Exception of type…
Jim Evans
  • 6,285
  • 10
  • 37
  • 60
2
votes
1 answer

SSRS BIDS 2008 Bubble chart - bubble legend size

Does anyone know how to make the bubble chart legend (pictured) bigger? Not the text, but the actual bubble's that are so small you can barely see them.
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
2
votes
2 answers

SSRS BIDS 2008 R2 Bar Chart Colour fill expression Legend

I have the above barchart with the following expression under the following section: SERIES PROPERTIES > FILL > EXPRESSION =iif(Fields!classification.Value="RFC","#56ca29","#ff6969") This works fine in terms of putting green for all the RFC's and…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
2
votes
1 answer

SSRS BIDS 2008 Bubble chart - Bubble size

I am using SSRS BIDS 2008 to produce a bubble chart. My chart has around 80 bubbles that are sized on a certain field, however the majority of my bubbles are tiny with 5/6 being massive. I need to somehow adjust the sizing ranges and believe I do…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
2
votes
1 answer

SSIS Deploying Master - Child packages in MSDB

I have a master SSIS package with three child packages and all these packages are part of a single solution. I 'm calling child packages through Execute Package task and connection managers pointing to child packages on the file system. Now i want…
Phoenix
  • 411
  • 4
  • 9
  • 22
2
votes
1 answer

Dynamics CRM 4/2011 - Report Writing

I'm looking for some guidance on report writing for Dynamics CRM. Our current CRM is Dynamics 4.0 - which is few years old. It's an on-premise version. I have been working with this CRM for the past few days and I understand that I have an awful lot…
user338195
2
votes
3 answers

Reporting Services Report Deployment / downgrading problem

I have a reporting services project with lots of reports developed in SQL server business intelligence development studio that comes with sql server 2008. I want to deploy these reports to a server that has reporting services 2005 only but the…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
2
votes
1 answer

SSAS - Data Cube Hierarchy not visible in Excel

Initial Request: Create hierarchies over customer names and product descriptions. Problem: I created several similar hierarchies and the product description hierarchy is not visible in Excel Supporting details The computed columns for each…
David Benham
  • 1,164
  • 11
  • 17
1 2 3
…
49 50