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 8: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? :?:

Posts: 1
Joined: Fri May 05, 2006 7:38 pm

Postby Brian Donahue » Mon May 08, 2006 5: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 That's a much better place for general questions about SQL Server.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 0 guests