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

The information in this article 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 Mobile Edition
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Workgroup

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 "Source - test * " 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

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.

Modification Type:	Major	Last Reviewed:	2/21/2006
Keywords:	kbtshoot kbdesign kbsql2005ssis kbprb KB911003 kbAudITPRO