Need help with VB.NET and SSIS. I Have 0 Knowledge of VB.NET

[DarkStarThresh]

HI everyone.
I need to make a Task Script in SSIS that can read s CSV FILE and then modified it.
In the last column the person who write the information add some NEWLINES so some information is added in another row.
I need to read the file, found the rows with the problem and rewrite it with the lost information and delete the rows with problems

As you can see the text in the row 5502 should be in the last column of the row 5501 and then delete the row 5502

[codegazer]

I'm afraid you're taking slightly the wrong view.
You can't move data and then 'delete row 5502'. This is a CSV file and all you do is to read the file, check each line in turn, adjust the data if need be, then write the file back to disk. You won't delete a row, you just won't write an empty one.

[DarkStarThresh]

Thank for the answer :)
There is way to read the file make some IF or FOR that ignore the row when this have less than X characters and then copy all the rows to a new file ?

[codegazer]

I'm not here to write code for you, but I'm happy to point you in the right direction. (see below)

It gets more slightly more complicated if you need to append something to the previous line as per your example, but this should get you started. Have a go - people will help more if you will try.

Something on the lines of. . . .

 
Open filename1 for input as #1
open filename2 for output as #2
   While not EOF(1)  
      read line from file1
      if line is ok
         write line to file2
      else
         ignore
      end if 
   wend
close #1
close #2
 
 

[DarkStarThresh]

Thanks, you really help me a lot!!
I was doing something like that but with your help i can make it better.
Thanks again