I agree with Nishant's answer. With his approach you would be doing the parsing of the data in an application which would split the input and then send the data via stored procedure to the database for insert.
If you want to send the line in its entirety to the stored procedure and have it do the split and insert all in the database,
this may help you.