Search results for query: *

I'm hoping someone out there can shed some light on this issue. Not after a solution as we have the process working but looking for insight on why this occurs. I have a SQL 2005 SSIS (this is not an issue with SSIS but rather in the underlying SQL Database) process that extracts data based on...

Good read on Package configs. SSIS: Parent package configurations. Yay or nay? Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck

This has a nice set of add ins for SSIS and SSAS. I recomend getting the latest code and compiling it yourself as it has more features than the last compiled release. Bids Helper I am also posting this link in the SSIS forum as it has a number of features that are targeted at SSIS and some...

This has a nice set of add ins for SSIS and SSAS. I recomend getting the latest code and compiling it yourself as it has more features than the last compiled release. Some of the tools address the GUID issue we have probably all encountered when using a template package along with better...

Bit of a debate going on regarding these 2 values. My understanding of this has been that SSIS will look at these 2 values and then makes an analysis of the dataflow to determine how the average size of a row in the dataflow ad how many rows it can fit within the 10MB (if you leave the...

I know MrDenny has taken and passed the MS 70-446 exam and was wondering if he or anyone else can give me some insight into it. I have transcenders being order but curious how it compares to 70-445. Paul --------------------------------------- Shoot Me! Shoot Me NOW...

If you are thinking about taking this test and haven't been working in al areas of BI for years all I can say is STUDY. this test covers the following: SSAS SSIS SSRS Data Mining both admin and dev aspests. It has to be the most insane certification test ever. Paul...

SSRS 2005 SSAS 2005 I Have a report that uses a SSAS 2005 Cube as it's data source. I have to add 2 prompts with One of the prompt values being based upon the value of the other prompt. In my cube I have [Date Dimension].[Fiscal MMMYY] which is the basis of the filters. THe need is for...

I found this helpful in better understanding when,why and how to do somethings in SSIS. Integration Services: Performance Tuning Techniques Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck

Has anyone come across and efficient method to organize calculations within the Meausres. The issue is pretty simple. I have a cube with 45 Measures of which there are approximately 15 various calculations that users want/need to be able to see each measure by Items like YTD Prior YTD and...

Not sure how many of you may have seen this already. OLAP Design Best Practices for Analysis Services 2005 Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck

Background: Process is ETL for a data warehouse. Design is multiple SSIS packages, 1 package per process task (ie Package for Patron Dimension load, package for Fact table load etc). I control the execution and order of execution, obviously dimensions process prior to fact tables, through a...

I have a SSIS package, part of a data warehouse ETL, that Reads in from 2 source tables approx. src 1 = 350K rows. src 2 = 120K rows This are both sorted in the extrat and then merged together in a Left outer Join (merge join task). Based on specific column conditions in a conditional split...

I have report that has # charts and 2 matrix grids. Each of these is within a seperate List container to allow the graphs to generate based upon the groupngs. The issue I am having is that when exporting to PDF for every page that has a graph or grid the next page is blank. I have gone...

I sent a request a couple months ago about the SSAS 2005 getting it's own group since the difference between the 2 is extensive. Maybe if others do as well we may see it as a group like we did with SSIS. Shoot Me! Shoot Me NOW!!! - Daffy Duck

A must read for anyone developing BI using SQL2005 toolset Project Real. There a significant differences between AS2K and SSAS 2005 that make design and development different between the two products. Shoot Me! Shoot Me NOW!!! - Daffy Duck

Let me start by stating, this is my first time working with oracle. I have a client who has provided me with what appears to be a file backup of one of their source systems. The backup contains multiple directories and files Directories include ARCHIVE LOGS, Findata, database control file...

Recent thread got me thinking on the information being passed in this forum. So I thought it would be intresting to see what peoples experience and opinions are regarding MSAS. Shoot Me! Shoot Me NOW!!! - Daffy Duck

I had a process that I had to kill. The process had ran over night and didn't seem to be progressing. I used the KILL <<SPID>> to end the process. I know and expected the spid to then enter a KILLED\ROLLBACK status. However when I check the state of the rollback with KILL <<SPID>> WITH...

I know this issue has hit me more than once. While researching another issue I was having I came across a tip somehwere (sorry read so many resources I don't remember), that had an excellent solution to the problem of an execute_package_task being mapped to an older version after you have...