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

How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade…
Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
8
votes
3 answers

SSIS Connection Error

I have the following code written into an SSIS Script Task to connect to my SQL database: ConnectionManager cm; System.Data.SqlClient.SqlConnection sqlConn; System.Data.SqlClient.SqlCommand sqlComm; cm = Dts.Connections["QUAHILSQ03"]; …
NealR
  • 10,189
  • 61
  • 159
  • 299
7
votes
1 answer

SSAS cube with multiple DB

I have 3 databases with the same structure, but different data, since they are from different clients. Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use or access one DB. What I want is to be able to use…
Raii
  • 303
  • 1
  • 4
  • 15
7
votes
6 answers

Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a strange error(bellow): Can someone give an…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
7
votes
2 answers

Can you monitor the execution of an SSIS package, in BIDS, as it runs on the server?

Although my title states my current goal, I am open to alternative solutions. In short, I have a series of SSIS packages that are scheduled to run on a nightly basis, on our SQL Server machine. Due to various updates that happen in the ether of my…
RLH
  • 15,230
  • 22
  • 98
  • 182
7
votes
5 answers

Query not working in SSRS 2008, or BIDS 2008, but does in SSMS

Environment DB Server (DWH prod & dev + SSRS prod) Win XP SP3 SQL Server 2008 Ent Corporate LAN No remote query timeout restrictions for DWH, i.e. they are set to 0 600 seconds for remote query timeout set for the SSRS DB server No restrictions on…
Adrian Torrie
  • 2,795
  • 3
  • 40
  • 61
6
votes
2 answers

TFS CI issue with a SSIS package

Build started 16/11/2011 9:24:11 AM. Project "C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln" on node 1 (default targets). ValidateSolutionConfiguration: Building solution configuration "Development|Default". …
Christo
  • 2,330
  • 3
  • 24
  • 37
6
votes
6 answers

How To Bid A Development Project?

I have landed a side project where a company wants me to develop a database / smart client to track participants in their various programs. This app will be written in C# and MS SQL Server. I was wondering if there are any tips on how to actually…
Strategon
  • 151
  • 2
  • 9
6
votes
3 answers

Access to the Path Error in Visual Studio

This issue was resolved with SQL Server 2008 R2 Cumulative Update 5 / SP1 / SQL Server 2012 RTM On occassion when I try to build a Reporting Services project as part of either deploying or previewing a report in Visual Studios I receive the…
Registered User
  • 8,357
  • 8
  • 49
  • 65
6
votes
2 answers

SSIS Flat File error "Text was truncated or one or more characters had no match in the target code page."

I am working on a SSIS project. I have a Flat File Source (csv) and OLE DB as destination. I have a column named WrapUpName with a data type Unicode string [DT_WSTR] with a Outputcolumnwidth - 50 that only contains either of these data…
Vian Ojeda Garcia
  • 827
  • 4
  • 17
  • 34
6
votes
1 answer

Reduced printing functionality in SSRS BIDS 2008 R2 "Preview" tab or bug?

Problem: Printing from within BIDS 2008 R2 "Preview" tab hangs and must have the process ended in task manager. Facts I can set the report as StartItem under Debug Configuration Properties for the project and then run, producing the Preview window.…
knslyr
  • 640
  • 4
  • 8
6
votes
3 answers

How can I "specify a dataset aggregate" in this SSRS Expression?

I need a row value in my SSRS report that is a calculated one based on a couple of fields that are already being used in the report. I want it to display in the textbox named 'textboxPercentageValue'. In semi-plain English, the expression/formula…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
6
votes
1 answer

SSIS Package runs fine in Visual Studio but fails when run manually on the deployed box

I have a script task that transfers certain passed in object from one server to another. This is the code public void Main() { try { string schemaName =…
bootkick
  • 482
  • 1
  • 5
  • 18
6
votes
1 answer

How can I use pixels in Visual Studio instead of inches?

I'm making reports in Business Intelligence Designer Studio (VS 2005). My reports will be viewed primarily on the screen, and I'd like to change my ruler to pixels instead of inches. Is this possible?
Nathan DeWitt
  • 6,511
  • 8
  • 46
  • 66
6
votes
4 answers

SSRS Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

I have a reporting solution with several reports. Up to now, I have been able to add a dataset based on a SPROC with no problems. However, when I try to add the lastest dataset, and use a SPROC for its query type, when I click on Refresh Fields I…
user1551329
  • 83
  • 1
  • 1
  • 4
1 2
3
…
49 50