Hi All I have data In excel in the below format Id Address Name 1 #302Bangalore Sanjeev 2 No302Bangalore Sanjiv 3 500 Bangalore Ramesh I want to dump this excel data into SQL table . I want my output to come in my table in below format ID Address Name
1 302bagalore Sanjiv 3 500Chennai Ramesh All the data should come only once and there was a spelling mistake (Sanjeev and Sanjiv) also Address should start with number E.g 302 or 500,there should not be any special character or text before integer in Address
.. I have taken Excel source and OLEDB destination Transformation,but what other Transformation should I used to achieve this, I tried using Derived column but didnt help,How to use it here..
View Complete Post