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
  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
  3. Madhivanan Moderator

    or you can import data to staging table ;get required data and load them to source table
  4. cmrhema New Member

    Thank you Madhivanan and Hendrik for your inputs, it helped me to solve the issue

Share This Page