Post reply

SSIS - text file

  • October 28, 2008 at 7:54 am

    #125621

    Hi,

    Hope you are doing fine. I have a text file with the following structure

    12744045,082708,div,cs,osg , 87.50,cash , , , , ,

    ;QDV :Dividend Transaction Qualified

    12744045,082708,cdt,ca,30267u108, 2030.00,cash , , , , ,

    ;CSMR :Cash/stock merger - Please edit

    12744045,082708,dbt,cs,30267u108, .00,cash , 200.000, , , ,

    ;CSMR :Cash/stock merger - Please edit

    I need to extract the second line which starts with ; (semi-colon) and put it along side the first line. And delete the space in the second line. In the same way, 4th line which starts with a ; should be put along side the third line.

    If anyone has an idea as how to go about this file, please let me know. Thanks in advance.

    Thank You,

    Sai

  • October 28, 2008 at 8:42 am

    #890681

    Hi Chinna,

    Thanks for your reply. Please send the mail to my email id at gowthamvalla@gmail.com. If it is possible, can you please explain me the logic. Thanks in advance.

    Thank You,

    Gowtham

  • October 31, 2008 at 11:31 am

    #892486

    import everything in stage table then delete not required rows

    or simply import required data in main table.

    thanks

  • November 1, 2008 at 7:33 am

    #892711

    Implement script source component and you can customize your parsing logic as much as you want.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply