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? ...
I currently work for a bespoke software agency. Does anyone have any experience of how to win well priced work? It seems there is so much competition from offshore/bedroom program teams, that cost is extremely competetive these days. I feel that it is very different compared to a software product company or an internal it department, in...
I currently use Visual Studio 2008 SP1 and have been migrating older projects into VS2008 but existing SSIS and SSRS (2005) projects have not been compatible with VS2008. It has been a pain to maintain those BIDS projects as a separate solution. I have been considering upgrading to SQL2008 but because our dev, test and production platf...
I would like to automate the deployment of my SSIS and SSAS artifacts to remote development SQL Server 2005 & 2008 instances on a scheduled basis. What would be the best solution for this? I am using TFS 2008 as the source control system, so I'd like to integrate the solution with MSBuild and a scheduled Team Build. ...
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 bid out a price for the job? Should I charge a flat rate (if so how do you charge it?) Sh...
I have a reporting services project with lots of reports developed in SQL server business intelligence development studio that comes with sql server 2008. I want to deploy these reports to a server that has reporting services 2005 only but the deployment is failing. I'm wondering if any one around here has been able to deploy reports dev...
In the "Layout" screen of an SSRS designer (Visual Studio 2005), the DataSets panel no longer displays. Previously it was in the same area as the general Toolbox panel. Anybody know how to get it back? ...
Group, I have Visual Studio (VS) 2005 and 2008 installed on my local machine. I am creating SSIS packages using BI Studio and the package will build and run fine on my local machine. However, as soon as I move it to the server I get the error: Error SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level insufficient for component......
I am trying to deliver an SSIS package to SQL Server 2005 Enterprise Edition running on Windows Server 2003 R2 (64bit). The package itself is quite simple, just a basic read/write of a MySQL table (testing the integration). I am able to build and deploy the package on my development machine, and I'm able to debug & build the package o...
Not too familiar with dtsx packages - can they be created/run outisde Visual Studio? Is BIDS (Business Intelligence Development Studio) just required to do all the above (in Visual Studio) or is it an independent development enviroment for dtsx packages? Please shed some light if you can (and get some eazy rep)! ...
I have been trying to win some bids at RentACoder.com, but I haven't had much success. Do you have a particular piece of copy that you use to help communicate professionalism to the clients? Is there a particular formula that you have for estimating the bidding price? ...
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 perhaps group the prompts into section. I'm just getting into using SSRS so my knowledge i...
I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anyb...
Consider these 2 machines: #1: Full SQL Server 2008 without Team Explorer (test SQL box) #2: Development box with Visual Studio 2008 SP1 with Team Explorer I use Team Foundation Server 2008 and would like to check SSIS projects into source control. Do I need to install BIDS as a separate Visual Studio 2008 shell in my machine #2? I ...
I have a reporting service report and I can't seem to figure out how to reorder the columns in the table control. Is this possible with editing the rdl file directly? ...
I've got the following report setup: 1. Letterhead (not in the header, since i only want it on the first page) 2. List control with some data when i export the report to PDF, and the contents of the List are less that one full page - my letterhead is displayed on the first page (the rest of the page is empty) and the List content gets...
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), two textboxes, and a footer. First textbox has a little bit of text, and second textb...
Hi! 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 non-time table in the data source, in order to get to the Date template). I am trying t...
My installation of Visual Studio Team System 2008 (Development Edition) does not have it. I can't find it in the SQL Server Enterprise 2008 installer either. ...
I'm newly getting into creating and programming reports using SQL Server Reporting Services. One thing that bugs me right off the bat: I can't seem to find an easy way to tell the BIDS (Business Intelligence Dev Studio, a.k.a. Visual Studio) to use the metric system for measurements - you know - millimeters, centimeters etc., instead o...