Here is the Stored Procedure code for importing comma seperated CSV files to table. CREATE PROCEDURE [dbo].[sp_ImportScript]@filepath varchar(2000)ASBEGIN TRYdeclare @tmpsql varchar(3000)set @tmpsql=’BULK INSERT table’set @tmpsql=@tmpsql + ‘ FROM ”’ + @filepath + ””set @tmpsql=@tmpsql + ‘ WITH (FIRSTROW=2,FIELDTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘,ROWTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘)’EXEC(@tmpsql)select @@rowcountEND TRYBEGIN CATCHDECLARE @ErrMsg nvarchar(4000), @ErrSeverity intSELECT @ErrMsg = ERROR_MESSAGE(),@ErrSeverity = ERROR_SEVERITY()RAISERROR(@ErrMsg, @ErrSeverity, 1)END CATCH
