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
4
votes
2 answers

Deploy VS2013 SSIS packages to SQL Server 2012 & edit in VS2012

I'm afraid I know the answer to this already, but I'm hoping someone can point me in a better direction. I just finished developing a large ETL project using VS2013. My dev machine has SQL Server 2012 installed, and everything works perfectly…
ItJustWerks
  • 551
  • 6
  • 20
4
votes
1 answer

SSIS 2012 - Best pattern for project-package-environment connection configuration

What is the 'best practices' way to configure connections in SSIS 2012 project (that will be deployed to the server)? Documentation and Google shows multiple ways to accomplish this, but which way takes full advantage of the 2012 project/deployment…
davewilliams459
  • 1,679
  • 2
  • 15
  • 24
4
votes
2 answers

Capture aggregate value from data flow task into a variable

I have an OLEDB (SQL) data flow source (A) that pulls a result set from a stored procedure and throws the results into an OLEDB (Oracle) data flow destination (B). Is there a way to capture an aggregate value from the dataset into a variable, all…
dev_etter
  • 1,156
  • 13
  • 32
4
votes
2 answers

SSRS Unable to Login and Deploy

All, a peculiarity has shown up in SSRS. We have an ASP.NET 4.0 Web Application which interfaces with SSRS's ReportServer. Our reports are all developed in BIDS 2008. Normally, I build a report, manage my deployment configuration (in this case, 01 -…
Matt Koster
  • 219
  • 1
  • 2
  • 8
4
votes
1 answer

Quickly changing SSIS-packages data source parameters for easy migration

I would need to migrate a SQL database from Sybase to MS SQL Server. Before doing the actual migration on the production server I first created an SSIS-package with SQL Server Management Studio's Import/Export Wizard for testing with other…
Muuse
  • 177
  • 1
  • 1
  • 9
4
votes
2 answers

How to check if SQL Server BIDS is installed

i want to create sql server integration service package by the use of Business Intelligence Development Studio but don't know why this studio is not getting open from sql server group, only command window gets open and suddenly closed, whether BIDS…
c.jack
  • 375
  • 1
  • 3
  • 18
4
votes
0 answers

Subreport Performance Difference Between SSRS and BIDS

I've got a report in SSRS that contains two subreports, but it's taking a very long time to show the final report. According to the SSRS Execution Log, the report is spending ~140ms in data retrieval, ~20minutes in processing, and ~20ms in…
Adam Dunn
  • 1,079
  • 2
  • 14
  • 27
4
votes
4 answers

TFS Modify Merge With Delete To Become Merge Without The Delete

I ran into a problem trying to merge from integration to feature branch. The trouble started with these 3 actions: 1) Added project ABC to Solution1 in integration branch. 2) Branched Solution1 to feature branch. 3) Deleted project ABC from…
JM Hicks
  • 1,282
  • 1
  • 11
  • 22
4
votes
2 answers

How to force a textbox to split, rather than move to a second page in SSRS 2005 (PDF Export)?

This question is a follow up to my original question, I've done a bit more reseach, i narrowed a problem down quite a bit. I've also uploaded a sample .rdl to illustrate the problem I've got the following report setup: a header (image in the body),…
roman m
  • 26,012
  • 31
  • 101
  • 133
4
votes
1 answer

How do I pass a table as a stored proceedure parameter inside an SSIS DataFlow

I am trying to write an SSIS package to transfer data from one database to another (straight copy, the tables that I am transferring to and from have the same structure). I am selecting a subset of the records (the ones that have been created or…
Hypersapien
  • 617
  • 2
  • 8
  • 23
4
votes
1 answer

BIDS SSRS Report query timeout issue while using Stored Procedure with timeout settings set appropriately

I've ran into a Timeout issue while executing a stored procedure for a SSRS Report I've created in Business Intelligence Development studio (BIDS). My stored procedure is pretty large and on average takes nearly 4 minutes to execute in SQL Server…
BrianJB10412
  • 43
  • 1
  • 3
3
votes
2 answers

SSRS BIDS Report Manager - Control

Is there anyway to have more control over Report Manager, is seems bizzare for such a sophisticated product to allow next to no control over the report manager section other than rename folders and place reports and report parts in these folders, as…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
3
votes
2 answers

SSRS report losses formatting in Report Manager via Internet Explorer

I have a report that renders a report header on its own page and then two pages for each member that it finds. The report will render each page correctly for the report header and the first member listed but all formatting is lost when the page…
PerPlexSystem
  • 704
  • 1
  • 15
  • 30
3
votes
3 answers

SSIS Count of Object Variable?

I am using SSIS in BIDS 2008 and I am trying to get a count of an Object Variable containing a list of files. Any idea on how to do this? Thanks!
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
3
votes
2 answers

SSRS BIDS 2008 R2 pie chart data labels overlapping

As seen in image, the data labels are overlapping and making the data difficult to read. Anybody know how to sort this? Have now updated the question as I have changed the PieLabelStyle to Outside and in the picture you can see in the design view…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
1 2 3
…
49 50