HI

Many thanks for the reply. I also saw this article but could only restart the server late friday afternoon. I then tried the export to Excel again and it seems...

Hi Burninator

Got that one as well, its really a pity that a style sheet cant be applied to ssrs, i see that they say even in the new release, it...

I think this is the option that Im sort of looking for.

http://www.keepitsimpleandfast.com/2011/11/how-to-implement-style-sheets-in-your.html

Still a bit of coding, but I ahve a few ideas of my own.

But, any other suggestions...

Some say when you have some difficult to do, give it to a lazy person, because the lazy person will find a easy way of doing. Im a lazy person......

Hi Koen.

Thanks for the suggestion. Sometimes its the small things that you over look. Can you believe that I forgot about the directing of an error row in the component....

Hi Koen, thanks for the always quick replies!

The component that fails is the dataflow task and in there the flat file source. (the data conversion for column ".." returned status...

The package runs, no problem, seems to do the look-up just fine..

Jsut that the input column lenght is not the same as the reference column lenght. I know, not the end of the world, but...

But as mentioned, if selecting the Ignore...

yes ive never used the soundex before but for instance the result for Wentworth and Wonderboom is the same. The one is English name and the other Afrikaans place name,...

Ok, will check on the fuzzy lookp, luckly Im already using SSIS, so should be a problem. (Didnt even think about the fuzzy), thanks

kypizzle (10/5/2011)

---

I actually found that you can change scope by moving the variables in the XML based code file. It's a bit complicated, but if I have time I'll...

Hi Martin.

Thanks for the response. I was goolging over the weekend and see that there is a few shortcomings in SSRS. But I'll take what you said, and apply it.

I...

Thanks for starting me off in the right direction, however

On both PC and Server, the regional settings is set to English South Africa. If I look at the report itself...

glen.wass (7/13/2011)

---

instead of subqueries google temp tables, i prefer to create a temp table and then innner join instead of using subqueries

however, it can depend on what you are trying...

Thats correct:-), check on the destination table on the commit size and rows per batch. This I have found makes a huge difference on the time it takes to complete...