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

Using SSIS BIDS with Visual Studio 2012 / 2013

I want to use SSIS /BIDS project in Visual Studio 2012. I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2012. VS 2010 was installed first followed by MS SQL 2012 which got me BIDS integrated with VS…
frictionlesspulley
  • 11,070
  • 14
  • 66
  • 115
45
votes
6 answers

How to access ssis package variables inside script component

How can I access variables inside my C# code which I've used in Data Flow -> Script Component - > My c# Script with my SSIS package? I have tried with which is also not working IDTSVariables100 varCollection =…
Ashfaque Ali Solangi
  • 1,883
  • 3
  • 22
  • 34
26
votes
9 answers

How can a software agency deliver quality software/win projects?

I currently work for a bespoke software agency. Does anyone have any experience of how to win well priced work? It seems there is so much competition from offshore/bedroom programming teams, that cost is extremely competetive these days. I feel that…
Chris Barry
  • 4,564
  • 7
  • 54
  • 89
24
votes
4 answers

Disabling SSIS Package Validation when Loading a Package in the VS Designer

I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the packages, the designer always validates every Data…
RLH
  • 15,230
  • 22
  • 98
  • 182
23
votes
1 answer

Positioning tables and charts in BIDS SSRS

See (image.1) - As you can see, in the design view I have my two tables on the left and two pie charts on the right, all neatly positioned. See (image.2) - Now I preview the report, and as you can see, I am not allowed the second pie chart along…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
22
votes
3 answers

How do I display 'No data available.' when there are no rows to show on the report?

I am building an SSRS 2005 report using BIDS. My report filters on date. When the selected date returns no data rows the report is blank, just the title is displayed, no table or column heading. How can I change this to display a message like No…
Tony Borf
  • 4,579
  • 8
  • 43
  • 51
20
votes
7 answers

Default Values for Parameter not Working in SSRS 2008 R2

I have a report (BIDS SSRS 2008 R2) that has a parameter that allows the user to select multiple values from a list (Sales Regions, lets say). I want, though, since the list is long (15 or so possible values) have selected by default the 2 values…
Amarundo
  • 2,357
  • 15
  • 50
  • 68
20
votes
1 answer

How to Add a File to the SSIS Project Miscellaneous Folder

I'm using BIDS2008 and I want to add a file to the Miscellaneous folder of my SSIS project. I have tried: to drag-and-drop a file to the folder icon in Solution Explorer - not allowed to right-click the folder icon - return 0 menu options to…
JM Hicks
  • 1,282
  • 1
  • 11
  • 22
18
votes
3 answers

Parameterized OLEDB source query

I am creating an ETL in SSIS in which I which I want my data source to be a restricted query, like select * from table_name where id='Variable'. This variable is what I defined as User created variable. I do not understand how I can have my source…
user1765876
17
votes
2 answers

How do I upgrade SQL Report projects (rptproj) to Visual Studio 2012?

Were I work we are currently using visual studio 2008 because 2010 did not include the bids stuff, I have now been asked to test out whether 2012 is any better so we have a virtual machine that I've been allowed to work on and we've got visual…
user1271242
  • 223
  • 2
  • 3
  • 7
16
votes
5 answers

Make SQL Server Reporting Services use metric measurements

I'm newly getting into creating and programming reports using SQL Server Reporting Services. One thing that bugs me right off the bat: I can't seem to find an easy way to tell the BIDS (Business Intelligence Dev Studio, a.k.a. Visual Studio) to use…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
16
votes
5 answers

Installation of SQL Server Business Intelligence Development Studio

I have installed Microsoft SQL Server 2005. This consists of the configuration tools (SQL server configuration manager, SQL Error and usage Reporting, SQL Server Surface area configuration, Reporting Services configuration) and SQL Server Management…
Sheetal
  • 853
  • 6
  • 15
  • 22
14
votes
1 answer

SSRS report files (.rdl) how to upgrade to latest?

I have been using Visual Studio 2010 for Reporting Services projects, with a SQL server 2012 reporting services back-end. To display the report we went from version 10,to 11 with the Reporting viewer in asp.net like so with no problems. <%@…
Michael Rudner Evanchik
  • 867
  • 1
  • 8
  • 19
14
votes
2 answers

Can you reorder columns in Report designer (bids 2005)

I have a reporting service report and I can't seem to figure out how to reorder the columns in the table control. Is this possible with editing the rdl file directly?
Jason Horner
  • 3,630
  • 3
  • 23
  • 29
14
votes
2 answers

Set Tablix row height to a specific number in SQL Server Report Builder 3.0?

I'm trying to set the row height of the detail row to a specific value, like 0.5 in. If I click on the Tablix handle for the detail row; it selects the row but the Size property does not expand for the Height property or allow entry for something…
Dan Metheus
  • 143
  • 1
  • 1
  • 4
1
2 3
…
49 50