Search results for query: *

Is there an 'in place' upgrade from sql 2005 to 2008? The server in question uses not only the DB engine but SSRS, SSAS, SSIS & the job agent etc. I'm guessing it will be a case of new install & re-attach all of the DB's and re-deploy SSRS, SSAS, SSIS etc from the original code (projects)? I...

Hi all, I’m using 2008 SSIS and any help or suggestions with my project would be appreciated. I have a delimited file source in which there are different types of rows (different column mappings). However the first four columns are uniform and allow me to identify what type of row it is and...

Hi, SSRS SQL2005 SP2 Standard Edition. Is there any way to move where the users "my reports" folder is located. Thanks A

Hi Folks, I'm trying to get a count from a table where the values in a [DATE] column are more recent than a specified lapsed time. Here is the code so far which doesn't appear to work given the Sysdate and the values in the table. ---- select count(*) as StatusResult from table1 where...

To save a lot of work I want to create a new SSIS package which is based on an existing project/installed package. The end result will be that both packages will be installed/running on the same server. What’s the best approach for this, save the project again using ‘save as’? copy and...

Using 2005 vb.net is there a way I can get the current line number of a streamreader. I guess I could just have my own counter and + 1 within the loop but is there a way to obtain from a property? This is sort of what I have ... Thanks -----------noddy code Dim FilReader As...

Hello, Using 2005/.NET Framework 2.0 I want to append complete files together. Simple with dos or unix but I'm not sure of the best way to do this in VB. For example I want to copy c:\dir1\filename1 to c:\dir2\filename1. If the file does not exist in dir2 it would be a direct copy but if the...

Is it possible to read the value (text) of either the current tab in IE7 (or a specic tab based on a part string search) into a variable in VB. I'm refering to the text on the actual tab itself not the page. As I'm sure you can tell, I'm not a VB developer I just dabble a little. Thanks in...

I have a report with a grouping, typically each group has 5 - 6 rows and a value. I want the report to have an overall sum() total based on the last() value of the group. like .. order,seq,value 123,1,245 123,2,300 123,3,100 group total = 100 order,seq,value 456,1,246 456,2,400 456,3,900...

I have a main report which is grouped on cost_centre & order_no displaying various qty's etc. I have then created another report which is also grouped on cost_centre & order_no but displays product information. I have added the second report as a subreport and created parameters for cost_centre...

New to SSRS 2005 and looking for a basic pointer. I have a SSAS cube as a data source. I want to select cust_id, prod_dept_id, ord_qty in one data set (filtered by various background attributes) and then have another data set with the same columns but filtered differently. Fine OK have done...

Sql 2005: SSAS 2005: Is it possible to configure a job agent job which runs an SSAS command on an SSAS server on another domain? (eg.cube or dimension process) Job agent / DB engine on one server and SSAS on another server in another domain. Thanks A

I have deployed a package to sql server(B) msdb. When I schedule the package using the job agent SSIS step on server (B) it will not save the job and errors with 'the specified '@subsystem is invalid'. I assume this is because server (B) does not have SSIS installed (true). If I run...

SSRS,SSAS 2005 SP1 Has anyone had any experience of using the URL render with report parameters **when the report is based on SSAS 2005** the following works fine when the report is based on a SQL query dataset but I cannot get the &paramtername= to work at all on parameters set up in a SSAS...

I know that AS2000 did not allow outer joins to dimensions. Has this changed for AS2005? I know all the work arounds such as dummy records/keys etc as I've been using them over the years, I just wanted to know if its changed in 2005. Thanks A

I'm trying to do what should be the simplest of things but I'm banging my head against the wall. I have a flat file with fixed width (8) date as yyyymmdd. I want to import this into a table with smalldatetime data type. I would have thought as its yyyymmdd I could just map it and it would be...