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

How do I remove an Expression from a variable in SSIS?

I have an SSIS package* built in BIDS 2008 with a variable whose value was originally being evaluated as an Expression. We now set the value in a different way, but I can't for the life of me figure out a way to remove the (now invalid) Expression…
Alex
  • 2,681
  • 3
  • 28
  • 43
3
votes
2 answers

Cannot see RDLC code tab in SSRS visual studio

I am doing some SSRS examples from a book. The book shows several tabs in visual studio - app.config, report1.rdlc (This is XML code for report1) , form1.designer.vb, form1.resx, report1.rdlc[design] (This is a graphical table/gui form of…
Steam
  • 9,368
  • 27
  • 83
  • 122
3
votes
2 answers

How to perform a Merge using the LIKE operator (or equivalent) in SSIS

I have been searching for this answer for quite sometime and so far, have not found a solution. I am creating a Data Flow Task in SSIS, and I need to join 2 tables on different data sources using the LIKE operator, or FINDSTRING, or CONTAINS…
Thomas07vt
  • 219
  • 1
  • 4
  • 11
3
votes
2 answers

How to group rows (bassed on CustomerID) using Pivot in SSIS?

I am practicing SSIS and currently working on Pivot transformation. Here's what i am working on. I created a Data Source (Table name: Pivot) with the following data. Using SSIS, i created a package for Pivoting the data to have the following…
TanmoyDB
  • 89
  • 2
  • 9
3
votes
3 answers

BIDS "Start Debugging" button not working

This is a very strange issue. In BIDS/Visual Studio, the "Start Debugging" button does not run the active package that I am working on. Instead it opens another package in the project (always the same one) and runs that one instead. I can only…
user2704110
  • 31
  • 1
  • 2
3
votes
2 answers

Is it possible to transform connection strings when deploying reports? (SSDT BIDS For VS 2012/SSRS)

Firstly, this is not my area of expertise, so I apologise in advance for my lack of intuition and naivety when it comes to this sphere. I am merely trying to help out a colleague. Also, please let me know if this fits better on the DBAdmin…
Moby's Stunt Double
  • 2,540
  • 1
  • 16
  • 32
3
votes
2 answers

SSAS - script partitions possible?

I was recently tasked with partitioning a large cube and I ended up creating 15 partitions on several measure groups. It's sped up the processing time considerably. This was done in BIDS on a development copy of the cube. My question is on deploying…
Jeffrey Bane
  • 592
  • 1
  • 10
  • 40
3
votes
1 answer

Change default NullProcessing setting for a cube or project in BIDS

Simple question - is there a way to change the default NullProcessing setting from Automatic to Preserve? When you have a measure with NULL values in some rows these NULL values are by default changed to 0 due to the default NULLProcessing setting.…
sdjensen
  • 56
  • 1
  • 5
3
votes
1 answer

BIDS, Standard and Enterprise Edition in SQL Server 2008

Does SQL Server 2008 - Standard Edition (64-bit) support Business Intelligence Development Studio (BIDS)? If yes, please let me know how to do it. What are the main differences between SQL Server 2008 Standard Edition and Enterprise Edition? Is…
Mahesh
  • 1,465
  • 4
  • 19
  • 23
3
votes
2 answers

SSRS Adding text box that accepts input for printing

Using Business Intelligence Development Studio, I am creating a report for SSRS that requires the user to add a few notes before being printed. The notes do not need to be sent back to the SQL Server that the report is being generated from, they…
Luke Wyatt
  • 1,126
  • 2
  • 12
  • 23
3
votes
2 answers

SSIS Excel to SQL import -- First 6 rows of the file contains header-related information

I am working on importing thousands of rows(120K) of data from an excel file into a SQL Server. Now I am trying to use SSIS to accomplish this but I immediately ran into some problem considering the excel template that the excel file is built with…
Kobojunkie
  • 6,375
  • 31
  • 109
  • 164
3
votes
1 answer

How to display a sub-set of the selection of a multi-valued parameter in a text-box in SSRS

I have a multi-valued parameter called Faculty on a report. I want to display the selection in a textbox at the top of the report. The obvious solution would be: JOIN(Parameters!Faculty.Label,", ") The problem that I am having is that the first…
user1596554
  • 31
  • 3
3
votes
2 answers

Can I develop SSIS 2005 in BIDS 2008? the way we can select target framework in VS 2010

I have a BIDS 2008 on my machine, My production is SSIS 2005. Currently gettting BIDS 2005 is a bit difficulty. Can I use BIDS 2008 as BIDS 2005? I have seen couple of such instance in Microsoft technology. In Visual Studio 2010 we can target an…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
3
votes
2 answers

Grand Total value doesn't match with Top N Filtered values in SSRS

I have a report in reporting services. In this report, I am displaying the Top N values. But my Grand Total is displaying the sum of all the values. Right now I am getting something like this.Here N = 2 +-------+------+-------------+ | Area |ID …
asquare
  • 77
  • 1
  • 3
  • 11
3
votes
2 answers

Can someone help explain some of the new SSIS 2012 properties?

As someone who's learning SSIS, there are some new properties in SSIS 2012 that I can't find any documentation/explanations for. Thus, I'm hoping someone can explain them: In the Maintenance Cleanup Task, the BIDS property grid has a…
Craig
  • 1,890
  • 1
  • 26
  • 44
1 2 3
…
49 50