December 13, 2012 at 8:30 pm
hi firend i have a small doubt in ssis plz tell me howto solve this issuse
Source contains a varchar column. The data in the source looks as
Code:
abcd
1234
height
6890
1a2b
Implement a mapping to identify only pure numbers in the source and load those numbers in the target. The target should contain 1234, 6890.
how we acchive this task.
December 13, 2012 at 11:06 pm
A Transformation Script Component in your Data Flow Task should work fine. This article explains the technique well in that it creates two output streams, one for rows containing numeric data and one for non-numeric data, but you will only need to process the output stream with numeric data:
SSIS: Checking for IsNumeric() by Jamie Thomson
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 14, 2012 at 12:15 am
An alternative if you don't like coding:
put a data conversion task and convert the column to a numeric datatype.
Redirect the errors to another destination or throw them away (for example by connecting the red arrow to a multicast).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply