FIX: Error message when you try to run an SSIS 2008 package that contains a Flat File source and a text qualifier uses some special characters that are not supported by the W3C XML language specification: "An invalid character was found in text content"

Consider the following scenario:

• You have a Microsoft SQL Server 2008 Integration Services (SSIS 2008) package. The package contains a Flat File source.
• In the Flat File connection manager, you specify the characters of the text qualifier to some special characters that are not supported by the W3C XML language specification.
• You try to save or try to run the package.

In this scenario, the package does not save or does not run, and you receive the following error message:

Note If you try to preview the output columns, this problem does not occur.

This problem occurs because the characters that are used by the text qualifier in the Flat File connection manager are not represented in hexadecimal in the XML file of the SSIS package.

For more information about special characters in XML documents, click the following article number to view the article in the Microsoft Knowledge Base:

The fix for this issue was first released in Cumulative Update 6 for SQL Server 2008 Service Pack 1. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft SQL Server 2008 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2008 Service Pack 1 hotfix to an installation of SQL Server 2008 Service Pack 1. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

After you apply this hotfix, the characters that are used by the text qualifier are stored in hexadecimal format in the XML file of the SSIS package. The characters in hexadecimal comply with the W3C XML language specification.

For information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:

For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base: