I am using script component in ssis 2005 for converting tab delimiter to pipe line delimiter, while i am converting if any special characters are available then the my code is taking the rows till special characters and leaving the remain rows.
for example if i have flat file with 10,000 records.
If the special character is in 7000 row. while i am converting to pipe line delimiter it is taking up to 7000 rows and leaving the remain 3000 rows.
I want to take out the rows which has the special characters and save to one flat file and remaining rows should be processed.