SQL Server Performance

How do I extract a single string from notepad

Discussion in 'SQL Server 2005 Integration Services' started by cmrhema, Mar 17, 2009.

  1. cmrhema New Member

    Hi ,I have done some SSIS programs, wherein I take all data from notepad and insert into database.
    Now I have a notepad which will be in this manner"UnitNo:1548787878 Speed:01 Ignition:1 ............"
    In the above manner I will have a string which will be in a single line and or more than one line.
    I want to store the number that follows the unit number in one coloumn of the database and the rest in another column.
    How will I do that in SSIS. Can you please provide me with some hints or major steps as to how do I do it.
    Regards
    cmrhema
    cmrhema, Mar 17, 2009
    #2

  2. hendrik.sudianto New Member

    Hi,
    You can use Data Flow Task and add Script Component as source on it.
    The script component should have output columns UnitNo, Speed, Ignition,...
    The script should read data from your text file line by line and send the output to the output buffer
    hendrik.sudianto, Mar 23, 2009
    #3

  3. Madhivanan Moderator

    or you can import data to staging table ;get required data and load them to source table
    Madhivanan, Mar 26, 2009
    #4

  4. cmrhema New Member

    Thank you Madhivanan and Hendrik for your inputs, it helped me to solve the issue
    cmrhema, Mar 26, 2009
    #5

Share This Page