|
KhD
Starting Member
6 Posts |
 Posted - 11/01/2012 : 02:46:56
|
Hi,
I am working on an SSIS package where I need to read data from a CSV file and insert into SQL table. But before I do that, I need to do some pre-processing on the file.
The CSV file looks like this:
3004891W,Chander Shekhar Sud,In Force
3022180P,Carole Margaret Hill,In Force
-,-,-
3022181I,James Allen Hill,In Force
-,-,-
N601635J,Spencer John Privett,Auto Pup
-,-,-
I have to replace the "-" with previous (one row above) cell value.
Can someone please suggest how to do this?
I am flexible with the approach. It can be a script task or using a temporary table to hold the data, and then processing that data in a Data Flow Task.
Thanks!!
|
|
Copy previous cell's value to current cell in CSV
