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

I can't show the Deployment Settings in BIDS

I have an analysis services database which contains datasources, data source views, dimensions and cubes. I want to edit the Project Properties for it by right-clicking the highest level, then clicking properties, but I don't get anything: it…
daniel_aren
  • 1,714
  • 3
  • 24
  • 41
0
votes
1 answer

Importing Vanilla Forum to SQL Server

I'm trying to get the data from a Vanilla Forums export into SQL Server so I can then write some sort of script to import it into YAF.NET. I've tried with an integration services project and the SQL Server import wizard. The forums and users went…
Echilon
  • 10,064
  • 33
  • 131
  • 217
0
votes
1 answer

SSIS Excel Source OpenRowset From Variable Error - 0x80040E37

When configuring an Excel Data Flow Component (Source) using the AccessMode of OpenRowset from Variable and setting the correct variable, I get the following error when trying to configure the shape/preview the data: TITLE: Microsoft Visual Studio …
PeterX
  • 2,713
  • 3
  • 32
  • 42
0
votes
1 answer

Error converting using SQL server 2012 conversion wizard

I am using SQL Servers Integration Services Project Conversion Wizard and keep running into the following error: "An error occured while retrieving the value of property "CertificateContext". The error code is 0x800200009. I did a google search…
rigamonk
  • 1,179
  • 2
  • 17
  • 45
0
votes
1 answer

SSAS 2008 Dimension Wizard and the Date Template

Does anyone know how to use the Date Template with the BIDS 2008, SSAS Project, Dimension Wizard? I keep getting an error - rightly so, I suppose - "Dimension not generated because it is bound to a time binding" (after having selected Generate a…
Oana
0
votes
3 answers

Building whole SSAS cube does not work, building dimension by dimension works - build order?

I am having a strange problem when building a cube on SSAS. I have a fact table, let's say FactActivity. Then I have a dimension DimActivity, which has a 1 to 1 relationship with this fact, and all the foreign keys are bound to the dimension. So…
Mez
  • 4,666
  • 4
  • 29
  • 57
0
votes
2 answers

Why is the Edit breakpoints option missing from BIDS Control Flow tasks context menu?

I have an existing SSIS project that I am trying to debug. I can see the Control Flow tab correctly but there is no Edit breakpoints... option on the context menu, which appears when you right-click on Control Flow tasks such as Execute SQL Task,…
Yulia V
  • 3,507
  • 10
  • 31
  • 64
0
votes
1 answer

Unspecified Error After creating AMO programmatically

I have programmatically created the Basic AM Objects(AMO) for Oracle and It went well , To verify the created components I'm using BIDS and When I'm clicking the "Explore Data" Command from action menu It's prompting Error , And the Error is…
KalG
  • 117
  • 1
  • 1
  • 10
0
votes
1 answer

How could I recreate this using a table or matrix (Merging cells)

Here I have a manually created table using textboxes inside of a list object: The problem with this is that if one of the textboxes has too much text only it will grow while the others will remain the same height. Now the other issue is you can't…
John the Ripper
  • 2,389
  • 4
  • 35
  • 61
0
votes
1 answer

PDF layout different in BIDS and on Report Server

I have a report which spans multiple pages and has repeating row headers. When I preview / export the PDF in BIDS, everything looks fine, the row headers repeat on each page. However, after deploying the report to the report server and opening it…
Harry
  • 21
  • 6
0
votes
2 answers

Getting BIDS 2008 R2 to connect to Oracle using MSDAORA on Windows 8

I have a new dev machine, and I need to support legacy SSIS packages. The new machine is Windows 8 64 bit with a SSD primary drive (C:) and a regular HDD for data (D:). On it, I have installed BIDS 2008 R2 (and all the tricks to get it to work…
Scott
  • 1
  • 1
  • 1
0
votes
1 answer

Microsoft.AnalysisServices.AdomdServer.AdomdException in BIDS

We are using following MDX to create dynamic named set to generate future dates for one of our cube - LASTPERIODS(100, STRTOMEMBER("[Calenar].[Calendar Date].&[" + CSTR(FORMAT(DATEADD("D",100,[Forecast].[Date Recorded].CURRENTMEMBER.MEMBERVALUE), …
Kinjal
  • 21
  • 2
  • 6
0
votes
2 answers

Can I create a BIDS project in VS2008 with SQL 2005?

From what I can find online about using VS2008 to create a integration/reporting services project it appears I need to have SQL 2008. Does anyone know of a work-around that would allow me to use VS2008 with SQL 2005?
Toran Billups
  • 27,111
  • 40
  • 155
  • 268
0
votes
1 answer

How Can I Export Multiple Rows of Data into Multiple Word documents?

I need to generate multiple separate Word documents from one table-valued function call. The function is located on a SQL Server 2008R2 server, and I have Visual Studio 2008 with SP1, Visual Studio 2010, and Business Intelligence Design Studio…
Dan M
  • 15
  • 3
0
votes
1 answer

SSAS : Multiple Partitions

I have a situation where I 3 partitions in SSAS BIDS 2008 for different years. I need to know which partition is in use in current context and why? How to change it manually? For example, I have to partitions: P2001, P2002 and P2001-2002; user…
Raj Jayaswal
  • 468
  • 1
  • 9
  • 22
1 2 3
…
49 50