Many thanks. I did a quick search on Amazon etc and found no books at all so that would suggest it is a fair way off.

Cheers

Mark

Thanks,

I will have a look at that. I am currently playing with a conditional split then derived columns, then a union all to put it back into the error table....

step by step is good.

Wizard is ok for some basic stuff but you really cant beat a good 'human' design.

My choice would be to populate the transaction table...

Cant help with the suffix.

My first question would be has anything changed on the database side that would impact query time? Do you keep any logs of cube processing...

I chose to import the text files as very big varchar fields. This then gives the file import the best chance of success. Then once they are in staging I...

chris_hurley (11/9/2011)

---

An alternative method (not neccessarily the correct method but it works) is to do the following:

Start with an execute sql task that queries your table. Set result set property...

To do this I generally enable package configurations and use an XML file for storing the values.

Add package variables called TargetDatabase and Target Server as strings.

Populate them from...

Have ample experience. For me its just trying to make sure that my resume is right at the top of the pile and my daily rate will be as good...

I am looking at it slightly differently. Certification will add value to me and if I end up spending £200 - £300 then thats a lot cheaper than a weeks...

I took 2005 BI MCITP as it was the latest version when I sat the test. I have done MCITP 2008 database developer aand want to get my BI upto...

Many thanks for that will look into site settings more.

Any good web pages for 2005 report builder out there anywhere? I want to see hoe good or basic it is.

Cheers

Mark

Thank you very much

Mark.

It is geometry rather than geography so no longitude or latitude. The points are points in time and have a value at that time. It is not a straight line....

Congratulations.

I passed the MCTS as well. I do find the self test software good at finding gaps in your test knowledge.

Mark.

+1 on go for 2008.

For somone who wants to pick up and be competent quickly in AS the difference between the two is minimal. 2008 is just an enhancement...