Ran it in SQL Server 2000 & ran into a few errors...

1) NVARCHAR (MAX) x 2 had to be replaced with NVARCHAR (4000)

2) RAISERROR( '....' x 2 had to...

BUMP... as no answers yet...

Anyone at all know how to find the SPID for a DTS?

Any feedback on how I can do it in another way to avoid xp_cmdshell?

Trying to...

BUMP.... as no replies yet...

Anyone at all know how to find the SPID for a DTS?

Any feedback on how I can do it in another way to avoid xp_cmdshell?

Trying to...

BUMP... anyone know please?

How to link sysprocesses to sysjobs 🙂

Re:

sysprocesses.program_name 'SQLAgent - TSQL JobStep (Job 0xF1CA1968020D2647B0E1D42483AA2695 : Step 1)'

but how to match it to relevant sysjobs.job_id

There is a simpler way to...

Here's some more info... 🙂

--------------------------

Has anyone experienced problems with DTSRUN in a job whereby the job just hangs for hours until you kill it? Any ideas why this could be...

Hi Bru...

my post in the other thread (didnt realise how old it was sorry, did a search) was about a different problem with a similar script... was asking for...

I can't get that script to work on SQL Server 2000 unless I remove the [LastQuery] from select. Any ideas please?

Get this error if keep [LastQuery] in place:

-- Server: Msg...

BUMP... anyone know please?

I'm having a very similar problem... & need to know the SPID of a DTS so that I can kill it...

been looking at data in: sp_who2 & sysprocesses, anyhow here's...