OK, I see it now, the value here (to my mind) is as an independent "object broker", a sort of universal EDI. The automatic mapping seems a little bit of...

You guys aren't very ambitious are you?

Here's my list :

Sycophantic minions to cater for my every whim.

Exotic island locale.

Cash.

Helicopter.

Aston Martin DB9.

Shark pool (to keep sycophantic minions in line).

I would opt for a...

The one I liked the most was something that emulated the opening screen of the BBC Model B and then saved all text input to a network drive. I went...

Thanks Don, there was I thinking "I don't get why XML is useful to me" and I was being a bit of a thicky, when really it just isn't any use...

Hi Neil,

Well I wouldn't recommend housing your data crunching on a terminal server itself, but that is a factor based on number of users/speed required/money available.

Personally I would never recommend...

Doh!!! That got it - cheers!!!!

Sorry - I realise now I didn't explain the problem, which is, of course, that it doesn't actually work.

Performance is irrelevant to me - I'm only doing it once....

I was busily popping data in and out of temp tables to get to some conclusion and kept having to drop them so I could start again.

Someone popped their head...

That's a great link Jamie, thanks, that guy's blog is really handy for Oracle / SSIS.

Regards

Richard

Hi Walter,

Why not just call an Oracle sequence through your linked server?

SELECT isnull(ID,0) as "ID" FROM OPENQUERY(TLSTUK,'SELECT tls.seq_pcks_id.nextval as "ID" FROM sys.dual;')

That works for SQL 7 and 2000, I use...

If you're using the "wizard" for Excel connectivity this is exactly what is happening, I'm afraid it hardwires the data source of the machine you're using.

Also, I really couldn't agree...

Sorry John, I see now I didn't explain myself right - actually our approach was just to cut and paste the Oracle proc into SQL and call it from there...

Hi John,

It's really very simple, here's some of my code :

SELECT [ID], MATCHCODE_1, CAST(KZ_TVO AS CHAR(4)) AS KZ_TVO

INTO #austriaink

FROM OPENQUERY(TLSTUK,'SELECT ARTIKEL.*,FARBEN_LOESUNGSMITTEL.KZ_TVO

FROM TLS.ARTIKEL, TLS.FARBEN_LOESUNGSMITTEL WHERE ID LIKE ''00006%''...

Does anyone remember the first time they tried to connect an XP machine to a network?

It took me ages to find out that the bloody thing had already done it by...

It's not the server settings, they're correct as I've already said.

No, this is in the generation of the report model itself, I've found where it's doing it - it seems there...