Bulk Insert With Dynamic File Name

Hi everyone,

I am trying to bulk insert some data from a csv file to a table. I can do it as part of a button on click event, but don't know how to do it using a stored procedure. This is what I have,


ALTER PROCEDURE dbo.TestImportData
    (

    @filename varchar(50)
    )

AS

    BULK INSERT dbo.[TestTable]

   FROM @filename

   WITH

     (

        FIELDTERMINATOR = ','

      )

    /* SET NOCOUNT ON */

    RETURN


I get the error message "Incorrect syntax near '@filename', Incorrect syntax near 'with'). What am I doing wrong? What should I do? Please help!