Definitely use XML over the variable-assignment syntax, as SQL Server supports XML. The variable-assignment syntax is not documented. It works, but is not supported.

I might -- maybe, possibly, with luck -- have found a solution for your issue. Did I say: no guarantees?

I needed to execute command-line FTP from an SSIS package....

SSCrazy -- Thanks, helpful. I find myself wishing you could define things like data sources at the solution level, rather than always at the project level, but it appears...

Greetings. Since you seem to have been able to make a working connection to Oracle, would you be willing to post your code? I can make a linked...

At your suggestion, I tried this:

SELECT TOP 100 * FROM ORALINK..CATALOG.ORATABLE --SUCCEEDS

SELECT TOP 101 * FROM ORALINK..CATALOG.ORATABLE --FAILS

Alas, same issue. This is really strange. May have to revive...