DTS package does not exist?

I ran the DTS package using the DTSRun as following:
SET @.action = 'DTSRun /S'+@.server+' /U "sa" /P "correctpassword" /N
"DataMover" '
exec master.dbo.xp_cmdshell @.action
It ran fine in one server. And failed in another server. The error message
is:
Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
Error string: The specified DTS Package ('Name = '"DataMover"
'; ID.VersionID = {[not specified]}.{[not specified]}') d
oes not exist.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
The verified the DTS package named as "DataMover" does exist on the problem
server. The DTS packages in two servers are exactly the same. I'm confused
why it worked on one and failed on the other one.
Thanks a lot,
FLXI changed the
/N "DataMover"
to
/NDataMover
It woked about the change. I still don't understand why it performs
differently on two servers. FLX
"FLX" <nospam@.hotmail.com> wrote in message
news:%23paHNQDDEHA.4080@.TK2MSFTNGP09.phx.gbl...
> I ran the DTS package using the DTSRun as following:
> SET @.action = 'DTSRun /S'+@.server+' /U "sa" /P "correctpassword" /N
> "DataMover" '
> exec master.dbo.xp_cmdshell @.action
>
> It ran fine in one server. And failed in another server. The error message
> is:
> Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
> Error string: The specified DTS Package ('Name = '"DataMover"
> '; ID.VersionID = {[not specified]}.{[not specified]}')
does not exist.
> Error source: Microsoft OLE DB Provider for SQL Server
> Help file:
> Help context: 0
>
> The verified the DTS package named as "DataMover" does exist on the
problem
> server. The DTS packages in two servers are exactly the same. I'm confused
> why it worked on one and failed on the other one.
> Thanks a lot,
> FLX
>
>|||Hello,
The behavior you described is mostly like a bug mentioned below:
308801 FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space
http://support.microsoft.com/?id=308801
To resolve this problem, obtain the latest service pack for Microsoft SQL
Server 2000. For additional information, click the following article number
to view the article in the Microsoft Knowledge Base:
INF: How to Obtain the Latest SQL Server 2000 Service Pack
http://support.microsoft.com/?id=290211
Please check the service pack on your 2 servers.
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/?id=321185
If the services packs on your 2 servers are different, we can explain why
it performs differently on two servers.
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.