That great - thank you. I had been looking at Skilled Software's product originally, however the comparison table on the Xpress Apps site says enough.

Thank you for your reply.

Yes, running xp_cmdshell will run external apps.

Is there something specific that you are trying to do?

Interesting, I had wondered what the diff was. Thank you very much.

SyBase/PowerSoft InfoMaker may be worth a look. Not too expensive and has a few good tricks up its sleave. Especially the latest version.

I think that:

CAST(fldid as VARCHAR)+CAST(productfld as VARCHAR)

will give you the result you are looking for. By using CAST, you are changing them to have the same data types, the +...

As far as I am aware, standard edition only uses 2Gb max. Enterprise ed. will handle more.

Yes, the same security is being used throughout.

The machine that hosts the DTS is the machine where the job is scheduled. Everything is done from the same machine to avoid SQL security issues. Therefore executing the DTS...

There are definately no interactive elements.

Any other ideas?

TIA

sp_reassign_dtspackageowner

Is that an undocumented SP?

Yes, there is a trigger. I guess that is causing all the reads?

So is that good or bad?

I am probably just being a complete monkey, but I cannot find anything using the search!

Help!

I have since found a solution mind you:

From SP2 onwards, the file: Instcat.sql needs to be applied manually, as per:

http://support.microsoft.com/default.aspx?scid=kb;en-us;266337

Just in case anyone else was interested?

: )

Thank you for the help. However the solution on from MS simply says apply the latest SP. This error occured on SQL7 SP4?