dbTalk Databases Forums  

DTSrun package does not exist

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTSrun package does not exist in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
TJA
 
Posts: n/a

Default DTSrun package does not exist - 05-13-2005 , 12:15 PM






I'm running the following from the command line

dtsrun /S"servername" /N"packagename" /U"username" /P"password" and
receiving the following error

Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

Error string: The specified DTS Package ('Name = '"packagename"
'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

I've done some research and there is a documented problem out there in
regards to whitespace between the switch and the package name. I've removed
all of the whitespace, but I'm still getting the error. I'm run SQL Server
2000 Enterprise Edition SP3. Any help you could give me would be greatly
appreciated. Thanks.


Reply With Quote
  #2  
Old   
hch
 
Posts: n/a

Default RE: DTSrun package does not exist - 05-14-2005 , 03:18 AM






I tested with a simple example and you CMD line code works normally !!

so no errors on the command line ..but

Verifiy that your package is stored on your server in the msdb database
check the contents of the sysdtspackages table in msdb database
.........

hch





"TJA" a écrit :

Quote:
I'm running the following from the command line

dtsrun /S"servername" /N"packagename" /U"username" /P"password" and
receiving the following error

Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

Error string: The specified DTS Package ('Name = '"packagename"
'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

I've done some research and there is a documented problem out there in
regards to whitespace between the switch and the package name. I've removed
all of the whitespace, but I'm still getting the error. I'm run SQL Server
2000 Enterprise Edition SP3. Any help you could give me would be greatly
appreciated. Thanks.


Reply With Quote
  #3  
Old   
TJA
 
Posts: n/a

Default RE: DTSrun package does not exist - 05-14-2005 , 10:19 AM



hch...

Thanks for your help. I was saving the package as a structured storage
file, but saving on the server will work also. If I save it on the server I
don't have a problem so we'll just keep it that way ;-) Thanks for the help
again!

"hch" wrote:

Quote:
I tested with a simple example and you CMD line code works normally !!

so no errors on the command line ..but

Verifiy that your package is stored on your server in the msdb database
check the contents of the sysdtspackages table in msdb database
........

hch





"TJA" a écrit :

I'm running the following from the command line

dtsrun /S"servername" /N"packagename" /U"username" /P"password" and
receiving the following error

Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

Error string: The specified DTS Package ('Name = '"packagename"
'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

I've done some research and there is a documented problem out there in
regards to whitespace between the switch and the package name. I've removed
all of the whitespace, but I'm still getting the error. I'm run SQL Server
2000 Enterprise Edition SP3. Any help you could give me would be greatly
appreciated. Thanks.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.