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.

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.
Propriedades

ID do Artigo: 911003 - Última Revisão: 13 de jun de 2008 - Revisão: 1

Comentários