Bulk Insert with Errorfile

[Ma Oo]

I want error log file when I do bulk insert. My sample code is :

INSERT INTO tbl_test(
    USER_ID, CODE, EXCHANGE, UPDATED_DATE)
SELECT LTRIM(RTRIM(USER_ID)),        
        LTRIM(RTRIM(CODE)),         
        EXCHANGE = '11',
        UPDATED_DATE = getdate()
        FROM OPENROWSET(
        BULK N'c:\test.txt',
        FORMATFILE='c:\test.fmt.txt', 
        ERRORFILE = 'c:\ERROR.txt') A
But the error log is not appeared in this way. What's wrong with this code? 
When I tried like below, it's work well.
BULK INSERT tbl_test
 
FROM 'c:\test.txt'
WITH
(
FIELDTERMINATOR='|',
ROWTERMINATOR = '\n',
FORMATFILE='c:\test.fmt.txt', 
ERRORFILE = 'c:\ERROR.txt'

But I want to add some hard_coded field other than the fields included in the file. So I need to use with openrowset. Do you have any idea with second method to add some more fields, or any advise of what is wrong with first method? Thank you.

[Rabbit]

What you have will put the error log on the C drive of the SQL Server.