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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.