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

View products that this article applies to.

This article was previously published under Q308801

BUG #: 355042(SHILOH_BUGS)
BIG #: 102083(SQLBUG_70)

Expand all | Collapse all

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.

Back to the top

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.

Back to the top

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 (http://support.microsoft.com/kb/290211/EN-US/ ) INF: How to Obtain the Latest SQL Server 2000 Service Pack

Back to the top

WORKAROUND

All the arguments (switches) for the DTSRUN command should have a single space in order to avoid the problem.

Back to the top

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.

Back to the top