>Hi all
>
>Never having had to do this to an SQL database before, what's the best way to import a CSV file in an SP?
>
>Thanks

Hi dorris

I'd look at getting into SQL Server Business Intelligence Studio and creating a dataflow package (dtsx).

You can then import your csv file into a temporary table and then your SP can process that in whatever manner you want.

Here's a link

http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/

I've done a few of these now and my packages run in the SSIS store. I find its the easiest and neatest way to go.