GSquared

Problem is that we've got to use dynamic SQL first, to construct a SELECT statement that'll pull data from the inserted table, as opposed to using the data from the...

Hi Adrian

Yes, you got my meaning correctly - no problems there.

I was afraid that would be the case with server links..... unfortunately, some of the packages in question are using...

Carlos

Many thanx for that - this at least gives me a point of attack. I'll start digging along these lines.....

Regards

Dave.

Hi All

Further to this topic - we have a T-SQL script from the net that will take a DTS package from a structured storage file, load it into SQL Server,...

Jules

Many thanx for that - worked a dream.

David.

Hi Ray

OK. The core & customer records are in the same table on both the SQL Server & the Oracle databases.

We could pump all at once - but for reasons...

Hi Ray

Many thanx for that.

One question - do you have any idea of what the update stage's performance will be like?

The table in question is very large - holding several...

Hi Folks

Many thanx for the replies. I've managed to get things working..... not through ActiveX, but through putting a Dynamic Properties Task in the package to set the server connection...

Hi Phil

Thanx for that. I'd already thought about table variables - but, SQL Server 2000 won't allow them to be used as output parameters from an SP, only as a return...