I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?” In order to update the RDLs I would have to perform a, “Save As,”...
A long time ago I started working on two projects using SQL Server Business Intelligence Development Studio 2005 (BIDS). I wanted to keep working on these projects, so I upgraded from BIDS 2005 to SQL Server Data Tools Visual Studio 2015 (SSDT). After editing and then...
The disabled ruler feature within SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio (BIDS) (post SQL 2005) is one of my pet peeves! Whenever I use BIDS or SSDT I have to enable the ruler and I find this very frustrating. Since I...
As promised in yesterday’s blog post, here are a couple more BIDS error messages that I come across from time-to-time with quick ways to fix them. Error Message #3 This error message is about having too many variables passed to the stored procedure. The solution to...
Every so often I run across errors involving passing variables to stored procedures when I’m using Business Intelligence Development Studio (BIDS). We use stored procedures for all of our SQL Server Reporting Services (SSRS) reports, so I’m more likely than most to...
If you work with Business Intelligence Development Studio (BIDS), on very rare occasions you may see the following two errors: This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later. When you click OK you get: The query could not...
Recent Comments