I have a Stored procedure tha call a DTS package using
dtsrun
ie
exec
master..xp_cmdshell 'dtsrun /SsqlSERVER\Instance /Usa /Ppas
sword /Nget_spscripts /Agv_campid="C1"'
when run on the Production server I get the following
error

Error string: The specified DTS Package ('Name = 'M001
sp_dets'; ID.VersionID = {[not specified]}.{[not
specified]}') does not exist.

but whe run on other severs it works OK

Any ideas what to check for

So you specify a package name of get_spscripts and DTSRUN says it cannot
find m001.....?

Do you execute another package inside this package ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Allan" <Allen.penston (AT) sitel (DOT) co.uk> wrote

Yes it does call another dts package that is on the same
server

Is this the package that is referenced in the error message?

Is it using the ExecutePackage task?

Make it name dependent only.

Make the Execute Package Task name dependent only
(http://www.sqldts.com/default.aspx?216)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


<anonymous (AT) discussions (DOT) microsoft.com> wrote