Thanks steve

Do you have any idea of why Cube Editor -> Insert -> Calculated Cells menu doesn't exist in my machine?

I've been reading some docs to try this, but that...

Thanks, I suspected that.

And in the example, what are the benefits of using global variables instead of using local ones?

Do you know where none of my 5 servers (SQL 2000 Std) have the "Via group membership" option in the login propierties screens?

Yes, you're right. I had forgotten the EXEC prior to sp_executesql ¬¬  

Final code is like this:

DECLARE @mes NVARCHAR(2)

DECLARE @sql NVARCHAR(1000)

SET @mes = CASE...

Hi.

Just to point something:

"Key points (Figure 6):

I think you're really meaning MS...

Used a calculated field:

refurbished + (rejected*2), So I have 3 possible values in one single field.

Thanks

Maybe last post of Alamir in this tread could be useful:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=129940&p=2

Hahaha, good question.. congrats

Wow man, thank you very much!

It costed me 4-5 days of frustrations. 🙁

But it's finally running.

Thanks a lot Jim, I'm very thankful

One more thing:

By company politics we only have office 2000 (and Office 2003 seems not to be here prior to 2005).

Do you know if...

Centainly I don't have a clear image of what "Web Analysis" means, just thought that maybe this could causing me the problem.

I have SQL Server 2000 Standard, and made HTM file...

Thanks Jim.

Yes, I've changed that, I can run exactly same HTM file from my desktop or from server's desktop and all works fine, that means I have no problem with...

I don't know what to say, after a few hours more of tests I thought in jshorts's comment and I realized that I've never restarted server after Oracle client installation.

I've...

Yes, is the same version (same installation CD) and is the only change to server.

And if is something like that ocurring... Why run manually and not programatically? :-\

Sure, DTS just import some data from Oracle. Data go to temp tables & after copy them to prod tables.

I've recently removed/reinstalled Oracle Client due some problems.

DTS ran fine before these...