Error: -2147220460 (80040414); Provider Error: 0 (0)

[vikki_routhu]

Issued following command from command line:

dtsrun /S<servername> /U<userID> /P<password> /N<package name> /M<packagepassword>

Following error:
Error: -2147220460 (80040414); Provider Error: 0 (0)
Error string: Cannot find specified package in the storage location specified.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 713


It is executing fine from enterprise manager. Any help? :?:

Thanks
Vikram

[Brian Donahue]

Hello Vikram,

You may want to make sure that all of your arguments are in quotes if they have spaces in them. You could also get the package GUID from the server and use the /G argument instead.

You may want to ask this question on one of the SQL forums such as www.sswug.org. That's a much better place for general questions about SQL Server.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521