SQL Server SSIS Sample Component: UnDouble
Brief Description
UnDouble takes a text column, and, removes bracketing quotes if present, plus replaces double quotes inside the text with sinqle quotes.
On This Page
Quick Details
| File Name: | SetupUnDouble.msi |
| Version: | 1.1 |
| Date Published: | 1/26/2006 |
| Language: | English |
| Download Size: | 120 KB |
| Estimated Download Time: | 1 min 56K |
Overview
UnDouble is an SSIS dataflow component that:
- Removes quotes that bracket input strings if present.
- Replaces doubled quotes with single quotes inside the string.
The SSIS flat file adapter doesn't process qualified strings where double quotes are used to indicate a single embedded quote.
This transform takes a text column, and, removes bracketing quotes if present, plus replaces double quotes inside the text with sinqle quotes.
SSIS users that want to duplicate DTS 2000 flat file processing can call their output column unqualified, then place this transform to clear up the quotes.
The conversion is performed in-place. Select the desired string column on the "Input ColumnsTab" of the advanced editor, then change its Usage Type to READWRITE.
Included in this install is 4columns.txt, a file that contains a variety of quote/character combinations. Use a flat file source to feed this data to the UnDouble component.
This component is part of a series of components that illustrate increasingly complex behavior, each one exercising a greater proportion of the SSIS object model. If studying in order, this component follows SeeBuffer, and precedes ValidUnDouble. 
Top of page
System Requirements
- Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP
SQL Server 2005; Visual Studio 2005 Top of page
Instructions
Install and build as directed in readme.txt
Top of page
Top of page
