I should have pointed out that you don't have to use SSIS for this. You could implement this is a SQL procedure using the BULK INSERT statement. The only caveat here is that the file you're importing from must be accessible in the file system on the server. The permission required to use BULK INSERT is the server role bulk_admin or better.