FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them (308801)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
This article was previously published under Q308801
BUG #: 355042(SHILOH_BUGS)
BIG #: 102083(SQLBUG_70)
SYMPTOMS
When you execute a Data Transformation Services (DTS) package from a command line by using Dtsrun.exe, if extra blanks or spaces are present between the package name and the argument that follows, the package execution may fail. The error messages that follow occur even though the package exists at the specified location.
If you save the package you execute through DTSRUN to SQL Server, this error message occurs:
DTSRUN /S "ServerName" /N "parsetest" /E
DTSRun:Loading...
Error: -2147217900 (80040E14);Provider Error: 14262 (37B6)
Error string:The specified DTS Package ('Name = '"parsetest" ';ID.VersionID = {[not specified]}.{[not specified]}') does not exist.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
If you store the package you execute as a structured storage file, and there are multiple white space characters after the file path, this error message occurs:
DTSRUN /F "%drive%:\path\parsetest.dts" /E
DTSRun: Loading...
Error: -2147024773 (8007007B); Provider Error: 0 (0)
Error string: The filename, directory name, or volume label syntax is incorrect.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704
The error message may vary or not occur at all. Whether or not the error message occurs depends upon the order you specify for the arguments for DTSRUN. If you remove the extra spaces between the arguments, the package execution completes successfully.
CAUSE
The problem occurs due to incorrect parsing of multiple spaces between the arguments for DTSRUN.
Even though the package exists on your local SQL Server computer or in the location you specify, if there are multiple space characters between the arguments you pass to DTSRUN, the error message occurs.
RESOLUTIONTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND
All the arguments (switches) for the DTSRUN command should have a single space in order to avoid the problem.
STATUSMicrosoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.
| Modification Type: | Major | Last Reviewed: | 10/31/2003 |
|---|
| Keywords: | kbbug kbfix KB308801 |
|---|
|