Microsoft KB Archive/911003

= You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard =

Article ID: 911003

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-





SYMPTOMS
When you try to export a table by using the Microsoft SQL Server 2005 Import and Export Wizard, you may receive an error message that is similar to the following:

Could not instantiate the source component.

Error 0xc001f205: DTS.Pipeline: Object name &quot;Source - test * &quot; is not valid. Name cannot end with a whitespace.



CAUSE
This problem occurs when the SQL Server 2005 Integration Services (SSIS) package contains a table whose name ends with a character that is invalid in SSIS. Characters that are invalid in SSIS are not supported by the SQL Server 2005 Import and Export Wizard. The following list contains some of the characters that are invalid in SSIS:
 * ]
 * The space character
 * ]
 * The space character
 * The space character
 * The space character
 * The space character
 * The space character
 * The space character
 * The space character



WORKAROUND
To work around this problem, rename the table so that the name does not include any characters that are invalid.



STATUS
This behavior is by design.

Keywords: kbtshoot kbprb kbdesign kbsql2005ssis KB911003

-

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

© Microsoft Corporation. All rights reserved.