Hallo an Alle,
ich habe folgende SP:

CREATE PROCEDURE [dbo]._blkIns_FlatFile 
@FileName varchar
AS 
DECLARE @FullPath varchar
SET @FileName  = 'D:\inetpub\ftproot\' + @FileName
BULK INSERT m1.dbo.[User]
FROM @FullPath
WITH
(CODEPAGE = 'ACP' , FIELDTERMINATOR ='\t' , ROWTERMINATOR ='\n' )
GO

liefert mir diesen Fehler:
Server: Nachr.-Nr. 170, Schweregrad 15, Status 1,  Prozedur
_blkIns_FlatFile, Zeile 7
Zeile 7: Falsche Syntax in der N�he von '@FullPath'.

kann mir jemand einen Hinweis geben.
Im voraus dankend.
Gru�
Zeljko
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
ATTACK! Download Intrexx CRM-Studio Now!   http://www.intrexx.com
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp

Antwort per Email an