JWColby
jwcolby at colbyconsulting.com
Thu May 3 21:37:53 CDT 2007
OK, let's try this... The following is what I have stored. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[BulkInsertInfutor] -- Add the parameters for the stored procedure here @FilName varchar(255) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here DECLARE @FileSpec varchar(1000) set @filespec = 'D:\PSMData\INFUTOR\CSV\' set @filespec = @filespec + @FilName DECLARE @SQL varchar(1000) set @SQL = 'BULK INSERT Infutor.dbo.infutor from ' + char(39) + @filespec + char(39) set @SQL = @SQL +' WITH (FieldTerminator = ' set @SQL = @SQL + char(39) + '|' + char(39) + ', ' set @SQL = @SQL + 'ROWTERMINATOR = ' set @SQL = @SQL + char(39) + '\' + char(39) + 'n)' exec @SQL END When I try to do: Exec BulkInsertInfutor 'NAR_MT1.csv' I get: Msg 7202, level 11, State 2, line 22 could not find server 'BULK INSERT INFUTOR' in sys servers. TIA for all assistance, John W. Colby Colby Consulting www.ColbyConsulting.com