hi folks

this is one of those nagging issues I've been dealing with.

I run a DTS from an SSRS report. The datasource for the report is a
sproc which executes a package.

I've tried various drivers (this is SQL Server <-- Oracle) and the
package ALWAYS runs successfully by hand).

However, we have a HIGH frequency where the packages returns less
rows or even no rows from the datapump task in the package:

DECLARE @dtscmd varchar(500)

SELECT @dtscmd = 'exec master..xp_cmdshell ''dtsrun /SLIV0AP10
\SQL2000 /NMatlCostUpd /A bldschedno:8=AU8CP rptopt:8=CPSC /E'''

EXEC(@dtscmd)

tried numerous techniques as well (ie:
sp_OAMethod 'LoadFromSQLServer', etc.)

all with the same kinds of issues.

anyone ever faced this issue (and come up with a resolution)?

thanks rob