duh!!! dont I feel like a ....
Thanks John
works perfectly

Hi guys, thanks for the replies. requirments have changed slightly.
Initially, the data comes through from Oracle in 1 row on a yearly grane. I unpivot it to get dates...

Thanks guys, gives me some direction to explore.
Phil, its been a while. sorry

I did find a work around. set ScriptErrorHandlingMode to IgnoreAll

to understand what I am doing, check this ooout http://sqlblog.com/blogs/alberto_ferrari/archive/2009/02/05/measure-tool.aspx

cheers

Ian

Thanks Martin,

didnt cross my mind that he will be able to change roles if he has admin rights.

ian

thought so

thanks G

That worked.

thanks a mil John

Thanks for the help guys. we installed a64bit excel and that worked.

reports seem much faster now. 😎

hI GUYS, THANKS FOR THE HELP.

Its a 32 bit environment.

Another suggestion I got was to run the SQL service packs.

Will let you know.

Hi guys, thanks for the replies.

I switched of the service. deleted the cub file and redeployed. worked.

cheers

Ian

Thanks guys, I copied the result and put it into text pad so i could see the formating. It shows a space and thats why I assumed as much....

Yes Eric, I just moved it to a dev environment. then building a stageing and data warehouse. all i need for now is the structure of the source...

eXCELLENT. THANKS KOEN

i have code. was thinking of using this

SELECT 1

WHILE @@ROWCOUNT > 10000

BEGIN

DELETE TOP (1000)

FROM (loop through tables)

END

but what i need, is to loop throough the target tables easily

hI SCOTT, no, afraid not.

canned tabular.

sorry