Whole numbers from sql column using SSIS
I think you're asking about using IsNumeric and CharIndex in your source query and then throwing away the things that are not whole numbers.  I would change my source query to be

SELECT 
    S.* 
,   CASE
        WHEN
        -- This filters for only the numeric type of data
        ISNUMERIC(S.Value) &gt; 0
        -- this filters the non whole numbers
        AND CHARINDEX('.', S.Value) = 0
            THEN S.Value
        ELSE NULL
    END AS NewValue
FROM 
    dbo.Source1 AS S;


Otherwise, you're looking at either using a series of Derived Column Components or a Script Component to do the same actions.

References


CHARINDEX
ISNUMERIC