Can anyone please advise what i am doing wrong, I am trying to pass
variables to a DTS package using the following stored procedure, but the
variables do not look available in the DTS package (********* sensitive
information removed)

CREATE PROCEDURE client_update_jp

@CompId as varchar(20),
@BranId as varchar(20),
@UserName as varchar(50),
@nValue as varchar(50)

AS

EXECUTE master.dbo.xp_cmdshell 'DTSRun /S "******" /U "*******" /P "*****"
/N "Client_Update_Mail" /G "{D8BE8C4A-C616-4974-8F6B-C0AA7183F016}" /A
"CompId":"8"=@CompId /A "BranId":"8"=@BranId /A "UserName":"8"=@UserName /A
"nValue":"8"= @nValue /W "0" '
GO