Processing OutPut from exec command

Hi,
I am using exec command command to run xp_cmdshell ext SP.
the command line string given to xp_cmdshell is for executing DTS Packages.
i want to process the out put returned by the exec command in my stored proc
Is it possible to capture the out put in addition of return code(0/1),which
is returned by xp_cmdshell, if yes then how?
thanks in advance
Kailuxdeclare @.e int
exec @.=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:
> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages.
> i want to process the out put returned by the exec command in my stored proc
> Is it possible to capture the out put in addition of return code(0/1),which
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux|||declare @.e int
exec @.e=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:
> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages.
> i want to process the out put returned by the exec command in my stored proc
> Is it possible to capture the out put in addition of return code(0/1),which
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux

Processing OutPut from exec command

Hi,
I am using exec command command to run xp_cmdshell ext SP.
the command line string given to xp_cmdshell is for executing DTS Packages.
i want to process the out put returned by the exec command in my stored proc
Is it possible to capture the out put in addition of return code(0/1),which
is returned by xp_cmdshell, if yes then how?
thanks in advance
Kailuxdeclare @.e int
exec @.=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:

> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages
.
> i want to process the out put returned by the exec command in my stored pr
oc
> Is it possible to capture the out put in addition of return code(0/1),whic
h
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux|||declare @.e int
exec @.e=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:

> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages
.
> i want to process the out put returned by the exec command in my stored pr
oc
> Is it possible to capture the out put in addition of return code(0/1),whic
h
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux

Processing OutPut from exec command

Hi,
I am using exec command command to run xp_cmdshell ext SP.
the command line string given to xp_cmdshell is for executing DTS Packages.
i want to process the out put returned by the exec command in my stored proc
Is it possible to capture the out put in addition of return code(0/1),which
is returned by xp_cmdshell, if yes then how?
thanks in advance
Kailux
declare @.e int
exec @.=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:

> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages.
> i want to process the out put returned by the exec command in my stored proc
> Is it possible to capture the out put in addition of return code(0/1),which
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux
|||declare @.e int
exec @.e=master.dbo.xp_cmdshell ....
select @.e
"kailux4" wrote:

> Hi,
> I am using exec command command to run xp_cmdshell ext SP.
> the command line string given to xp_cmdshell is for executing DTS Packages.
> i want to process the out put returned by the exec command in my stored proc
> Is it possible to capture the out put in addition of return code(0/1),which
> is returned by xp_cmdshell, if yes then how?
> thanks in advance
> Kailux

Process Multiple Reports at once?

I have a project that has 10 reports that I need to schedule in various
combinations with different parameters on 5 different schedules, excel output
to a file server. Possibly up to 170 different reports a day so regular
subscription set up would be a nightmare to maintain. I have looked at
Data-Driven subscriptions however what I need is different report
combinations generated not different variations of one report. Something like
this:
Schedule 1
Package 1
Reports A, B, C, D, G (All use same data parameters)
Output to Folder 1
Package 2
Reports B, C, D, E, F
Output to Folder 2
Schedule 2
Package 1...etc.
Is there a way to accomplish this with SSRS, SSIS or SOAP (which I know nada
about) - What is the best process? Subreports are not viable since the
worksheet names cannot be set. (Using 2005)
Any suggestions appreciated.
--
ABNo ideas anyone? Must be asking the impossible :)
--
Allison
"allison" wrote:
> I have a project that has 10 reports that I need to schedule in various
> combinations with different parameters on 5 different schedules, excel output
> to a file server. Possibly up to 170 different reports a day so regular
> subscription set up would be a nightmare to maintain. I have looked at
> Data-Driven subscriptions however what I need is different report
> combinations generated not different variations of one report. Something like
> this:
> Schedule 1
> Package 1
> Reports A, B, C, D, G (All use same data parameters)
> Output to Folder 1
> Package 2
> Reports B, C, D, E, F
> Output to Folder 2
> Schedule 2
> Package 1...etc.
> Is there a way to accomplish this with SSRS, SSIS or SOAP (which I know nada
> about) - What is the best process? Subreports are not viable since the
> worksheet names cannot be set. (Using 2005)
> Any suggestions appreciated.
> --
> AB|||You could do it from within a programming environment... but I don't
believe this is possible within the standard portal.|||I need to do something similar...
I know that I've done this sort of thing with Active Reports and Crystal
Reports. When you create 1 report, then a second report, and want to stitch
them together and render as 1 PDF... I haven't come across anything that
pops out in the documentation for RS 2000 that can allow me to do this so
far. Should I be looking at 2005 to accomplish this or is 2000 sufficient?
"toddnappi@.gmail.com" wrote:
> You could do it from within a programming environment... but I don't
> believe this is possible within the standard portal.
>