Order# A has Collection of SKU's like below

1

2

3

4

5

6

7

8

9

SKU's 4, 6 & 8 are to be identified out of the order A.

Hope I made it clear.

My bad you were right. It should be 5126234194.

that would be 5126234194

Well. In a row value of alpha numeric code like 'E126W4SD', the above excel algorithm will provide values replacing the alphabets, based on alphabet series. Lets say an alphabet "A"...

let me try if that works. BTW...when I view the blank cell it should give me the NULL value instead it shows that there is a value in it, but...

this is happening in a null cell. A blank cell should show up as null but in this case the white space is represented as a value, which is skewing...

that works..thaks a ton.

My apologies.

I'm new to SSIS. I got partial information on google. Any links or videos where I can get a step by step download.