Hi Guys,
Here is my source data,
FName,LName,State
Frank,Smith,NY
Carla,James,Null
Norman,Sa,Null
Frank,G,CA
Chris,U,Null
How can I accomplish in above data through SSIS, Here is my destination look like.
FName,LName,State
Frank,Smith,NY
Carla,James,NY
Norman,Sa,NY
Frank,G,CA
Chris,U,CA
Here what I want, Start reading State Column from Top and pick that value and give the value until State field is not Null.
Please Help. I want this in SSIS, T-SQL is my last Option and my source is .xlsx FILE.
Thank You.