SSIS - CODEPOINT Function

CODEPOINT :

                         Returns the Unicode code point of the leftmost character of a character expression.

Syntax :

CODEPOINT(character_expression)

• character_expression must have the DT_WSTR data type.
• CODEPOINT returns a null result if character_expression is null or an empty string.

Reference - http://msdn.microsoft.com/en-us/library/ms137696.aspx

EXAMPLE : 

Sample data:

CREATE TABLE TEST123(ID INT IDENTITY(1,1),Column1 VARCHAR(40))
INSERT TEST123 (Column1) SELECT 'A12345678'
INSERT TEST123 (Column1) SELECT 'B12345678'
INSERT TEST123 (Column1) SELECT '123456789'

Scenario:

In the above sample data,if we are required to export only the rows with starting character as alphabet in the Column -  Column1.

If we are required to achieve the above scenario using SSIS ,  CODEPOINT function can be used .

 Use this expression in the Conditional Split Task as shown in below images :

     CODEPOINT(UPPER(Column1)) >= 65 && 
   CODEPOINT(UPPER(Column1)) <= 90