This should give you something to work with

Declare @cmdstr varchar(8000)

Set @cmdstr = 'pkzipc -add '+ @zippedfile +' ' + @srcfile

exec master..xp_cmdshell @cmdstr...

I realize that I am a day late and a dollar short, but if you want to know Version, SQL Install Path, Default Database Path, and then some you could...

And this is the Third part of teh script.............I know there are LOTS of ways to skin a cat, so no flaming please

--...

I do by creating a BAT (or CMD) file with this in it...........:

REM set the Folder name in this script

REM SET @OutputFolder       = 'C:\SQL_Rebuild_Scripts'

SET ServerName=DELL

isql.exe -S %ServerName% -E -d MASTER...

I never how this will format in here but is this what you are looking for?

PRINT ''

PRINT ''

PRINT ''

PRINT '+-----------------------------------------------------------------------------+'

PRINT '¦       List of users per role'

PRINT '+-----------------------------------------------------------------------------+'

PRINT ''

-- ===================================================================================

-- ===[ Lists...

I am Being Stubborn here

using MSDB

SELECT     step_name AS Step_Name, job_id, step_id, subsystem, command, database_name, server

FROM         sysjobsteps

WHERE     (command LIKE N'DTSRUN /~%')

Don, I am not sure I understand the Question but does this help?

-- ===================================================

PRINT ''

PRINT ''

PRINT ''

PRINT '+-----------------------------------------------------------------------------+'

PRINT '¦       DTS Package Details'

PRINT '+-----------------------------------------------------------------------------+'

PRINT ''

-- ===================================================================================

-- ===[ DTS Package Details ]=========================================================

--

-- Purpose   ...