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 control when BIDS opens a package in the editor when debugging?

I have a solution in Business Intelligence Development Studio (BIDS), that consists of multiple projects and multiple packages. There is one 'main' package which will execute several other packages in sequence. When running the solution in debug…
Daan
  • 6,952
  • 4
  • 29
  • 36
0
votes
1 answer

SSIS lookup transform

In SSIS I have a lookup transform which performs the function of only inserting new data into the table, call it tableY. So the process is the following: 0) Aggregate (group by) the primary key for the input row 1) Do a lookup with the current input…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

Perspectives using different fact tables, same dimensions

My client has asked me to create a different perspective for an existing cube that shows only a subset of the fact table. I'm not sure if this is even possible though. I was hoping that I can bring in the same fact table again, filter it, and join…
confusedKid
  • 3,231
  • 6
  • 30
  • 49
0
votes
2 answers

Indicators in SSRS

I have a column in SSRS report. The value is "True" or "False" or "Yes" or "No" or "1" or "0" Instead of showing that in that column, I would like to use indicator. I placed indicator in that column but need to set start and end property. How do I…
John Smith
  • 187
  • 1
  • 5
  • 12
0
votes
1 answer

SSIS automatic package execution

I want to automatically execute my SSIS package once a week at a specified time. I want to clear the entire database before I load the contents of a new excel file every week. I think I can use truncate statements for clearing the entire database.…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
2 answers

SSIS derived column convert string to date

I am trying to convert a string into Date using Derived column and I am using Flat File Source. I read bunch of articles on stackoverflow and followed the same steps but I am unable to convert my string into date format. Here is the string Tue Nov…
asquare
  • 77
  • 1
  • 3
  • 11
0
votes
1 answer

SSRS Report Custom Prompt Layout

Is it possible with business intelligence development studio to create an SSRS report and easily customize the way that the prompt fields are laid out (mainly the location)? It looked like it defaults to grouping them horizontally, I would want to…
Chris Klepeis
  • 9,783
  • 16
  • 83
  • 149
0
votes
1 answer

SQL Server: Business Intelligence Development Studio

I apologise in advance as I appreciate my question is a generic one, rather than focusng on a specific issue. After several days of hitting my head against a brick wall trying to learn SQL Server Reporting Services I have made little progress. I…
PJW
  • 5,197
  • 19
  • 60
  • 74
0
votes
1 answer

Data tab and dataset in Visual Studio 2005 / 2008

I have built some reports in both VS 2005 and VS 2008. In VS 2005 I have 3 tabs available on Design page - 'Preview' 'Layout' and 'Data'. In VS 2008 I have only the 2 - 'Design' and 'Preview' Can anyone pioint me in the correct direction as it is…
user1086159
  • 1,045
  • 5
  • 16
  • 24
0
votes
1 answer

LineChart using 2 Dataset in SSRS

I want to create a line chart using 2 set of values.First value (i.e line) will show open report and second value(i.e line) with show closed report. The x axis will show months and y axis will show number(i.e sum of report). I tried using the…
asquare
  • 77
  • 1
  • 3
  • 11
0
votes
1 answer

Sql Server Reporting Services parameter passing

I am creating a report such that when you click on a data point it opens up another report providing the details of that datapoint. My problem is the parameter passing. What I want to pass is the information from that datapoint. Thanks!
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
3 answers

Event Handler precedence in SSIS

I have OnPostExecute event handlers on all my control flow elements, but as soon as I put a OnError handler on the package level, I dont see the task level handlers anymore. Is this a known bug or is it something that I am doing wrong.
rvphx
  • 2,324
  • 6
  • 40
  • 69
0
votes
1 answer

Sql Server SSIS conditional insertion

I am trying to do an OLE DB Command to add rows to my table only when the primary key field does not already exist within the same table. This is what I have so far: insert into employee (employee_id, first_name, middle_initial, last_name) …
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

Sql BIDS aggregrate transform

I have a question about the BIDS aggregrate transform. My data flow task begins with an Excel source, goes through an aggregate transform, and then into an OLE Database. I aggregrate my data by a project_id. However, when I aggregate by the…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

Remooving reccurent entries in a table Visual Studio 2005

I have created a table in Visual Studio. That table has two columns. First is the name of a parent and second is the child name. In case one parent has several children I would like his name to appear only once (Not sure if it matters, but the data…
Paul Kar.
  • 1,293
  • 2
  • 21
  • 32
1 2 3
…
49 50