Post reply

How do I extract a single place from SSIS

  • March 17, 2009 at 10:24 am

    #155427

    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 column of the database and the rest in another column.

    How will I do that in SSIS. Can anyone please provide me with some hints or major steps as to how do I do it.

    Regards

    cmrhema

  • March 17, 2009 at 3:50 pm

    #961446

    Is this the way the data is actually coming along?, i mean is the heading like unit is repeating itself through out the text file?

  • March 17, 2009 at 9:51 pm

    #961557

    Yes the word unit will be repeated in each and every line and it will be termed as new line

  • March 18, 2009 at 8:19 am

    #961924

    When u create new flat file connection manager from General tab,use format as Ragged right from drop down option.Then move to column tab as you will see the image of your flat file and using the cursor you can select whereever you want to start a new column. To name the column just go to the advanced tab and specify whatever name you want inside the column box

    thanks

    Simon

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

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