Microsoft KB Archive/308801

= FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them =

Article ID: 308801

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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 &quot;ServerName&quot; /N &quot;parsetest&quot; /E

DTSRun:Loading... Error: -2147217900 (80040E14);Provider Error: 14262 (37B6) Error string:The specified DTS Package ('Name = '&quot;parsetest&quot; ';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 &quot;%drive%:\path\parsetest.dts&quot; /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.



RESOLUTION
To 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.



STATUS
Microsoft 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.

Additional query words: dtsrun parse variable parameter white space character

Keywords: kbbug kbfix KB308801

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.