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
don't worry all sorted now, ta "John Peach" wrote in message news:AF01C766-0DC1-48D9-9F66-A26BC4367C45@microsoft.com... > 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
