Sometimes you have to import a column that you suposse that is numeric but comes as string (e.g. a CSV file, or a staging table where all the fields are text), SSIS does not have an already made box for this task... but you can always use .net in SSIS !!
This articles explains you how to check if a given column / row value is numeric using SSIS and a .net script task.
|