LISTING 1: Stored Procedure That Transfers Data 
from a Text File to SQL Server

USE pubs
GO
CREATE TABLE dbo.MyDataIn (InData varchar(500))
GO
CREATE procedure myproc_loaddata (@Filein nvarchar(50)) AS
   DECLARE @SQLString NVARCHAR(80)
/* Build Command*/
SET @SQLString =
N'Bulk Insert pubs.dbo.MyDataIn from ' + N'N''' + @Filein + N''''
/* Execute */
EXEC (@SQLString)
GO
EXEC myproc_loaddata N'C:\swinv.log'
GO