BCP

Hejsa!

Jeg fyrer følgende af

Bcp pics..tmpAuditTrailUsers in C:\\PICSTempFolder\\AuditTrailUsers.txt -c -t# -r\\n -S (local)\\pics -U \"PICS\" -P \"PICS\" -k -R -m 1000 -o C:\\BCPError.log

AuditTrailUsers ser således ud

115#126#ABBManagerS#Fullname of ABBManagerS#1#
116#127#ABBManagerS#Fullname of ABBManagerS#1#
117#128#ABBManagerS#Fullname of ABBManagerS#1#
114#125#ABBManagerS#Fullname of ABBManagerS#1#

Tabellen tmpAuditTrailUsers ser således ud

1    AuditTrailUserID    int    4    0
0    AuditTrailID            int    4    0
0    [User]                    varchar    50    0
0    FullName            varchar    500    0
0    AuthenticationLevel    tinyint    1    0
0    CancelComment            varchar    500    1

Der er oprettet en bruger PICS med PICS som password!

Jeg får følgende fejl


Starting copy...
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword \'User\'.
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword \'User\'.
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword \'User\'.
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword \'User\'.

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total        1

Hvad fanden er det???