error executing package with command line dtsrun.exe

sqldba

2009-04-09 17:11:01 UTC

I figured it out, the package was saved in sql 2005 as a legacy dts package
and we wanted to import it into a sql 2000 and the package was saved with one
space character in the end like this "my dts package ". I put quotes to show
you there is a space in the end. And that's where I started seeing the error
mentioned in my previous email. It was a pain to think of a sapce in the
end, how I figured it out, through dtsrunui by generating the command line
and it revelaed the space in the end.

thanks
sqldba

Post by sqldba
Hi all,
I am getting following error when executing dts package in msdb or
structured file from command line using dtsrun.exe. The package runs fine in
enterprise manager but failed to execute from command line. This ia very
basic command and I am using dfor my other packages scheduled. I tried it on
different server still getting the same error. I even tried to run a simple
package other than this one with command line and it returns the same error.
This is so basic that i do not know how to ask. I am sure I am missing
something but I cannot figure it out. YOur help is greatly appreciated.
E:\Outbound>dtsrun /S servername /E /N "packagename"
DTSRun: Loading...
Error: -2147220460 (80040414); Provider Error: 0 (0)
Error string: Cannot find specified package in the storage location
specifie
d.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 713
sqldba