As an extra.. i think my problem is qutie different from the other thread.. the full error message is below:

...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_2   DTSRun OnStart: ...

Cheers Remi, this is a lot neater way of doing things!

Alex

Remi- hi again!

hmm annoying about the update thing. didnt realise.

not too sure this would work as i can't go on null values. basicalyl the full ticketing table contains details...

ok ignore the above.. sorry.. didnt realise it had to be running as a service!

thanks aanyway!

marv i shall investigate!

cheers!

Igor,

I'm doing a lot of work with string manipulation at the moment, and the AT and RAT functions will be certainly useful to me!

Cheers!

Alex

Well ,you lot have only gone and done it again!

Is this the most helpful forum ever?

Discuss

did it again!

my hero!

Fantastic!

I shall be setting up a shrine in your honour this evening 😉

Alex

Hiya, that's brilliant- thanks for the reply. My next question relates to the null part.

I'm using a linked server- so that patr of the statement actualyl looks like..

SELECT * FROM...