I'm calling DTExec from a stored procedure, using xp_cmdshell (trust me!).
It returns (selects) lots of status information which I'm not interested in, and which is causing problems as it's getting sent back to the web client - which doesn't like it.
(Even when the reporting switch is set to N - for No Reporting)
The only method I've found to 'swallow' the output is by exec-ing into a table which I then drop.
Is there a better way to suppress the output?
select @cmd ='C:\"Program Files (x86)"\"Microsoft SQL Server"\90\DTS\Binn\DTExec.exe /DTS "' + @PackageName + '" /SERVER "' + @MachineName + '" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING N'
CREATE TABLE #output ( Line VARCHAR(8000) )
INSERT #output exec master..xp_cmdshell @cmd
drop table #output