none
Special characters in text file, should be save that special characters rows into another flat file

    Question

  • Hi All,

    I have flat file input with tab delimiter.

    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.

    thanks in advance.

    Anil


    • Edited by AnilReddy07 Sunday, January 06, 2013 3:28 PM
    Sunday, January 06, 2013 3:25 PM

Answers

  • Anil :

    Here are some options as work around 

    You can use derived Expression to check and replace special chars in your columns 

    or use error redirect rows option 

    one former thread which might help in your case is 

    http://social.msdn.microsoft.com/Forums/eu/sqlintegrationservices/thread/c80d5285-a616-40e3-8443-19e4781b93be

    • Marked as answer by Eileen Zhao Thursday, January 24, 2013 2:53 AM
    Sunday, January 06, 2013 3:39 PM