Right, I got it, using the following sintax for the table name:

[font="Courier New"][Production.Product][/font]

But I had never tried it before because it is wrong.

SELECT * FROM works fine, thanks

I've done nothing, apart from defining the shortcut, as explained in the article.

I like the tool (I was used to use ALT<F1> to see table definition), but still there is...

Sorry, what do you mean "how to you go about that"?

The sp doesn't work for tables which are not in dbo scheme

The Oracle DB is 32 bit.

When I was using ODBC, I was able to choose for the 32bit System DSN (with odbcad32.exe located in %Windows%\SystemWOW64\ ).

And, anyway, checking...

Ok, solved in two steps:

- use "Ole BD for Oracle" instead of "ODBC"

- check “Use 32 bit runtime” in step execution option

Thank you

Carlo

I'm realizing this section is on sql server 2005, but I'm actually using sql server 2008 R2 64 bits

I wrote the username variable (executing the package) into a table, and it shows: ada\administrator

Which other information would I need to know?

No idea at the moment

thank you

carlo

I'll go throw it today an tell you...

I agree, that could be the point. Could you explain me how to write to a file the configuration details?

Thank you very much

carlo

Thank you, but it doesn't help.

My package is a very simple one, only for architecture test purpose.

So there's no functional problem, and it actually works if I launch it manually...

Thanks, that 's that i'm doing.

Anyway, it looks to me as a so normal situation (when using cascading parameters) that I was wondering if there's a built-in easier solution to...

Hello

a question about multivalue cascadeD parameters.

I have a parameter PRODUCT (key and descipcion) whose values are

PRODUCT TABLE

prodkey description

=== ========

1 ...

Yes, thank you

the instruction

sp_dbcmptlevel 'MYDBNAME', 90

has solved the problem