I have a table in sql server which is populated from oracle table . For this import i am using ssis . now I have columns of first name and last name . In these columns the data is not going in proper manner. This is because Some data is comming with ","(comma) in beween strings. exmp: lastname='Mor,g an' .
I want to get out of this. I want my data to be inserted in proper format.
If any commas in between or in last or in start of the string then it will eliminate it and insert corrected data to sql server.
I want to get out of this. I want my data to be inserted in proper format.
If any commas in between or in last or in start of the string then it will eliminate it and insert corrected data to sql server.
Comment