Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 911003 - Last Review: November 20, 2007 - Revision: 2.3
You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard
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.
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
To work around this problem, rename the table so that the name
does not include any characters that are invalid.
This
behavior is by design.
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
| kbtshoot kbdesign kbsql2005ssis kbprb KB911003 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate