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

How to install BIDS for SSRS 2012?

I tried the following: Install VS 2012 + Data Tools for 2012 - BIDS projects are not supported. Install VS 2010 + Data Tools from SQL Server 2012 media - in the middle of installation, it prompts for vs_setup.msi and when directed to VS 2010 media…
Victor Zakharov
  • 25,801
  • 18
  • 85
  • 151
0
votes
1 answer

How to keep List contents on the first page? (SSRS 2005 - PDF Export)

I've got the following report setup: 1. Letterhead (not in the header, since i only want it on the first page) 2. List control with some data when i export the report to PDF, and the contents of the List are less that one full page - my letterhead…
roman m
  • 26,012
  • 31
  • 101
  • 133
0
votes
1 answer

Why do all my 'Sum of Units' rows all have the same values in PowerPivot?

I'm pretty new to PowerPivot and have a problem. I created an SSIS project (.dtsx) to import around 10 million rows of data and an Analysis Services Tabular Project (.bim) to process the data model. Up until today, everything worked as expected,…
Sheridan
  • 68,826
  • 24
  • 143
  • 183
0
votes
1 answer

Multiple redirect rows to different outputs in SSIS

Hi is it possible to have multiple redirect rows (when error) in an SSIS control to different outputs depending on which column is in error? Thank you
user1589188
  • 5,316
  • 17
  • 67
  • 130
0
votes
1 answer

SSRS BIDS Unexpected end of file has occurred

I have come accross the following error in BIDS whilst working on one of my report parts. At the time I was playing around with an image that I imported into the project around 6 times, Visual Studio threw up an error about performance or memory, I…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
0
votes
2 answers

TFS source control of SSIS projects in Visual Studio 2008

Consider these 2 machines: 1: Full SQL Server 2008 without Team Explorer (test SQL box) 2: Development box with Visual Studio 2008 SP1 with Team Explorer I use Team Foundation Server 2008 and would like to check SSIS projects into source…
Gus Cavalcanti
  • 10,527
  • 23
  • 71
  • 104
0
votes
1 answer

Can we install BIDS on a sql server 2008 R2 & VS2012

How to use SSRS with sql server 2008 R2 and Visual Studio 2012 installed system.
mannu
  • 1
  • 2
0
votes
1 answer

SSRS DateTime Format - set to US not UK

I currently have a reporting services report created in BIDS 2005 and the database is SQL Server 2008 R2. My first issue is when I'm in BIDS and go to preview to test the report it only processes with the date in us format mm/dd/yyyy however if I…
DtotheG
  • 1,277
  • 5
  • 21
  • 35
0
votes
3 answers

SSRS 2008: Why does a declared query variable show in the "Define Query Parameters" window?

I'm having trouble creating a dataset in Reporting Services 2008. Here's the query I want to use (generic-ized for public consumption): Declare @PersonID as int set @PersonID = (select top 1 personID from People where name = @PersonName) select…
minameismud
  • 91
  • 1
  • 9
0
votes
1 answer

Setup Enviroment Sql server 2008 R2, BIDS, needing samples

I have installed SQL Server 2008 R2 SP3 express edition 64 bits, and the Advanced Services for BIDS. Following an Ebook tutorial I need a SQL Server AdventureWorksDW 2008 R2 sample database as the basis for building an SSAS cube". I am supposed to…
Danny
  • 221
  • 1
  • 6
  • 18
0
votes
1 answer

SSRS BIDS clustered stacked bar chart

Is there a way to create a chart in BIDS that combines the properties of these charts a horizontal stacked bar chart like…
trs
  • 2,454
  • 13
  • 42
  • 61
0
votes
1 answer

As BIDS 2008 is only 32 bit how can we develop for 64 bit?

I am working to get my packages running on SSIS 2008 64 bit. My pacakges used DSN so I made 64 bit DSN.. but as BIDS is only 32 bit I run into error like below. I think .Net Provider\Odbc Data Provider is 32 bit (as it is part of BIDS 32 bit) but…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

Using variables inside Execute SQL task query

I am a complete beginner in terms of SSIS packages. I really want to execute a stored procedure that takes in parameters with different values at each iteration of the foreach loops. So I'm wondering if anyone can give me an example (VERY VERY VERY…
anpatel
  • 1,952
  • 4
  • 19
  • 36
0
votes
2 answers

How to set a default value on a boolean parameter with an expression in SSRS 2008?

I am currently converting an inventory report from a web application into an SSRS report. I am trying to get the same functionality, but I am having trouble setting the default value of a boolean parameter based on the value of a previously selected…
Jim
  • 58
  • 1
  • 5
0
votes
1 answer

Making labels for pointer in BIDS

I have a gauge which has a scale with several pointers. What I would like to do is to make the value of the pointer and its title appear below them (the pointers, I mean). How can I do this?
kyooryu
  • 1,469
  • 3
  • 23
  • 48
1 2 3
…
49 50