I cant use BULK Insert as the client is asp.net site hosted on a shared server and dont allow CLR and it a pain to do a webclient pull then a save to folder then BULK INSERT into SQL table.

My code is trying to avoid the file save part of the data flow

.net webclient > SQL string > Store proc into table

But as you can see the splitter is dropping some rows.