get ssis package output from SP

Question

I have a SP that runs a SSIS package.

xp_cmdshell 'dtexec /f "F:\SSIS Package\test.dtsx" /Rep E'

When I run the SP in VS I get an Output window where I can see if it was successful. Is there a way to get the output from this into my asp.net application ?

Answer 1

One practice I've often seen is to capture the results into a table. Something along these lines:

create table #dtexecOutput(varchar(4000))

insert into #dtexecOutput exec master..xp_cmdshell 'dtexec /f "F:\SSIS Package\test.dtsx" /Rep E' 

select * from  #dtexecOutput