Viewing 15 posts - 286 through 300 (of 340 total)
Yeah, like I stated before if you haven't searched his site, Jamie knows SSIS inside out.
Here are a couple of links that might help you out in setting up your...
December 8, 2008 at 2:26 pm
Will you know or be able to generate the name of the file name? You can setup the file connection managers connection dynamically using expressions. You can also...
December 5, 2008 at 9:02 am
So in the SSAS database in the date dimension is there a relationship between month name and month? Which is related to which? You could just set the...
December 3, 2008 at 5:21 am
In regards to the keys in being alphanumeric in the source table, those would be referred to as natural keys. For best practices you want to typically stay away...
December 3, 2008 at 5:04 am
Seems rather unlikely that you would have 400+ metrics. I would think that some of these are possibly attributes of a store (like size, etc.) and not metrics, but...
December 2, 2008 at 10:33 am
It appears that you need to take a look at the dimension design in the SSAS database. Are the key and name column properties for this attribute set to...
December 2, 2008 at 10:17 am
With SSRS 2000 and 2005 there is Report Builder 1.0 and with SSRS 2008 there is still Report Builder 1.0 in the Report Manager for the time being. They...
December 2, 2008 at 8:54 am
It is included in every edition except Express (unless you are using the Advanced release).
Compare the Editions and features included - http://msdn.microsoft.com/en-us/library/cc645993.aspx
SSRS 2008 does not have a dependency...
December 1, 2008 at 10:06 am
Typically you would do this in your ETL process. Not sure how you have this setup currently (stored procedures, SSIS, etc.). Not sure what your requirements are to...
December 1, 2008 at 9:22 am
For more information about this you can refer to my previous posting in the TechNet forums here - PerformancePoint and SQL Server 2008
November 28, 2008 at 10:24 am
I would make sure that you have processed the dimension first and then try processing the cube. Typically data will get refreshed in the fact table and you will...
November 28, 2008 at 8:56 am
This isn't the only way to get at the result, but here is an example against the Adventure Works. Basically creating a set of the products excluding the item...
November 28, 2008 at 8:10 am
I have been working with Oracle 11g and SSIS on x64. The main issues I have seen are to make sure you have the 64bit Oracle Client installed on...
November 28, 2008 at 7:39 am
I have done this for PPS 2007 M & A and after you download and install SP1 you will be fine and you will be able to proceed with the...
November 28, 2008 at 7:32 am
nice job. was thinking that maybe you had to register asp.net with iis, but maybe that wasn't the issue or maybe it was resolved after you installed the framework.
November 21, 2008 at 8:24 pm
Viewing 15 posts - 286 through 300 (of 340 total)