Top "Bids" questions

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

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 …

sql-server sql-server-2005 business-intelligence bids
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 …

visual-studio-2012 ssis visual-studio-2013 bids sql-server-data-tools
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 - &…

c# sql database ssis bids
SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report. …

ssrs-2008 reporting-services bids reportbuilder3.0
Parameterized OLEDB source query

I am creating an ETL in SSIS in which I which I want my data source to be a restricted …

ssis bids
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 …

reporting-services bids
SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package

I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs …

sql-server sql-server-2005 ssis ibm-midrange bids
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 …

reporting-services reportingservices-2005 bids
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 …

sql-server visual-studio sql-server-2005 ssis bids