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

DTS Package Compare 2

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

Postby vikki_routhu » Fri May 05, 2006 9:11 pm

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
vikki_routhu
 
Posts: 1
Joined: Fri May 05, 2006 8:38 pm

Postby Brian Donahue » Mon May 08, 2006 6:12 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 0 guests