• 1) TRY_CONVERT could help

    2) SSIS has a Data Profiling tool that could help

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service