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

vikki_routhuvikki_routhu Posts: 2
edited May 8, 2006 1:12PM in DTS Package Compare 2
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? :?:



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
This discussion has been closed.