Search results for query: *

I need to upgrade my client tools to SQL 2008 R2 for SSRS purposes. However, I still need to deploy SSIS to SQL 2008. I cannot find anything to do with target version in BIDS. Does anyone know if this is possible? Thanks

Bear with me, I'm a long time Windows developer, I'm looking for a layman's explanation. I need to have the ability to assign directory permissions to multiple users. Is this the correct approach? 1. Create Linux groups, assign various users to the various groups. 2. Change the directory...

I don't work with webforms very often, so forgive my ignorance. I'm using a chart, and I want to format my Y-axis in the thousands with a K. For example, 300,000 would be 300K. Alternatively, I would just use 300 and leave the K off. At the present, my format string is the following...

I'm using Excel Services in SharePoint 2007 to connect to Analysis Services. I have a date hierarchy filter among my filter collection. I would like to be able to dynamically set the default date instead of just typing in something like [Date].[Hierarchy Name].[May 2009]. I've tried an MDX...

Windows 7 64-bit Ultimate C: Drive -- 60 GB SSD G: Drive -- 1 TB HDD I downloaded some files and the application which performs the download saved them to my desktop. Before the download, I had 22 GB of free space on the C: drive according to My Computer and Disk Manager. After the download...

Using SSAS 2008 Enterprise. I've got some reporting actions where I pass in member names as parameters to SSRS reports. Often, these actions do not work when called from Excel. I believe the main issue is the fact that the names of these members contain special characters which are invalid...

SSIS 2008. I am using the .net data provider for Oracle. The column in Oracle is defined as NUMBER (no precision or scale specified). The largest value in the column in the source table is in the low millions. I don't see how it would overflow anything. If I look at the Data Flow Path Editor...

My apologies for the thread title. I'm not really sure how to concisely articulate my question. This is SSAS 2008 Enterprise. Anyways, I am working with some financial data. This particular subject matter area is rather light in comparison to some of my other subject matter areas as far as...

SSAS 2008/Enterprise. I have an Inventory Measure Group wherein some of the measures are aggregated by FirstNonEmpty/LastNonEmpty (Beginning and Ending Quantities and Amounts), and others are aggregated by SUM (What quantity was brought in for example). Running a query which contains both a...

We're looking to format our accounting measures similar to the Excel Accounting format. In Excel, this format is _($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_) This doesn't work in SSAS 2008. Has anyone implemented an accounting type format? The key to it is that the currency symbol is...

SSAS 2008 Enterprise. I have a dimension with IgnoreDuplicateKeyErrors set to ReportAndStop. The dimension processes fine on it's own. When I try to process the entire database, I repeatedly get a duplicate key error as follows: Location is one level up from the bottom of the hierarchy...

I have a workbook where I have denoted some items with question marks. Now, I'm trying to find these items using Ctrl-F and the criteria being a question mark. However, Excel seems to interpret this as a wild card, and it is stopping on every cell. I've tried putting double quotes around the...

I'm creating staging tables in SQL Server to ETL data over from Oracle 11g. Using Oracle SQL Developer, I am looking at the DDL for many of these tables. Many of the columns are defined as such: Some_Column_Name NUMBER Since many of these columns are currently filled with NULLs, I'm not sure...

I'm using SSAS 2005 Standard Edition. I've got some calculations to create some semi-additive measures. They're basically beginning and ending amounts (non-additive over time). Query performance is OK until I include sub-totals and totals in my MDX report generator, wherein my report takes...

SQL Server 2005 Standard Edition x64, SP2. Every 15 minutes, I am getting the following error: Error: 4014, Severity: 20, State: 2 A fatal error occurred while reading the input stream from the network. The session will be terminated. Any insight to this would be appreciated.

On packages which use SQL Server as a source/destination with the OLEDB provider, the package is taking a long time to complete the Pre-Execute. After it finally completes, it is stuck at "Execute phase is beginning." This is SQL Server 2005 Standard Edition x64. The problem occurs from BIDS...

I've got an SCD wizard set up for a dimension. It's only got a dozen or so attributes and I have them all set to Historical Attributes (other than the Business Key of course). The problem is, it's detecting every row that flows through as a historical change. I've double checked the component...

I have tables with UNIQUEIDENTIFIERS as the primary keys. The default is NEWSEQUENTIALID(), to help with generating keys in ascending order by default. After inserting records into the tables, I want to be able to return the key value which was just inserted. This doesn't seem possible with...

I have two BO report files. I would like to copy the report from one of those files into the other file. I can't seem to find a way to do this. Anyone know if this can be done?

Has anyone seen this? http://msdn.microsoft.com/vbasic/future/default.aspx?pull=/library/en-us/dnvs05/html/vb9overview.asp I'm not sure what to think of it as yet. It talks about adding extensions such as sql-like query capabilities and xml inside VB.