from within a T-SQL script you can use Bulk Insert
/* load the tables with sample data */
BULK INSERT dbo.rm_source_codes
FROM '\\Todd\JobLog\ph_sc.CSV'
Make sure the file is located on the server or use UNC so the server can find the file if it's on the client.
Out side a script use BCP or DTS (which uses BCP)
Software engineers are trained to read and understand code; they are not trained in mind reading. Document the purpose not just the functionality.