Search results for query: *

I will start a thread later today discussing the differences as I have experienced. I will do my best to get this done. I have been away from here for about 6 months for health related issues but am trying to get back and contribute.

Ties, have a star for a very well worded explination.

ROLAP MOLAP and HOLAP are simply storage modes for your data. Some products are one or the other where MS SSAS allows you to choose. Simply put MOLAP (Multidimension OLAP) Data is preaggregated and stored in a non RDMS file system. MOLAP storage tends to produce the fastest cubes when...

do the filenames following a similar pattern? If so you can read the file names based on patter matching.

That will disable the entire dataflow, but if you want to disable 1 task within a dataflow you can't.

No you can't disble transfoms in the data flow. Your best bet is to save versions of your file.

This type of work maybe easier to do on the server as part of a source query if the source is SQL Server.

without knowing the details all I can say is depends.

Utilize 2 lookups the first you will want to use full cache and the second use partial cache. The partial cache will actually query the table for the record needed and then cache the record when found so additional references to this record need not be queried.

could you paste the error message not everyone has access to online storage sites.

If your query is that large and complex have you considered breaking it into smaller queries and or pushing off some elements of the query to SSIS? I can't imagine SSIS not being able to replicate some of the functionality of your query.

If you utilize an OLE DB connection SSIS can handle any oracle query that you can execute. Store yuor query as a variable and then in your oledb connection use the variable as your query source.

The problem as I see it is you submitted requirements how detailed they were I do not know, and what you recieved was what you asked for. Even if you had said I am open to other options if companies deal with a lot of requests most people have done the research and want a price for what they ask...

it probably depends what you are trying to do.

If you have SQL 2008 it is included but you have to install it seperately. If you don't have it in one of the Microsoft SQL directories you can get it here. Microsoft Connectors for Oracle and Teradata by Attunity

I either use an OLE DB Dest for oracle which does not provide a fast load option or the Attunity data providers that come as part of 2008 but require a seperate installation.

The best job in IT is the one where you do something you enjoy what you are doing and have a passion for what you are doing. The worst job in IT is the one that pays a lot. Yes we all need jobs that allow us to live and prosper the way we want but if you don't enjoy it and don't have a passion...

Having been in the BI world for around 10 years now, and seeing the growth in the amount of BI jobs and the type of projects I can say BI is booming right now. Is it you are bored with BI or are you bored with your BI implementation. If you have gone beyond true development and enhancement and...

Add a derived column to your data flow Add a new column and the assign the variable to that column.

have you tried the discussion board on the codeplex project?