Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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.

↑ Back to the top

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

↑ Back to the top

Workaround

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

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

Keywords: kbentirenet, kbtshoot, kbdesign, kbsql2005ssis, kbprb, kb

↑ Back to the top

Article Info
Article ID : 911003
Revision : 5
Created on : 4/20/2018
Published on : 4/20/2018
Exists online : False
Views : 105