• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1277
  • Last Modified:

FIELDTERMINATOR

I have this code

BULK INSERT tmpStList FROM 'c:\TxtFile2.txt' WITH (FIELDTERMINATOR = ',')

It works fine. But when I change the ',' to ';' it give an error message. My text file is separated with semicolon (;)
0
CochiseCounty
Asked:
CochiseCounty
1 Solution
 
jdlambert1Commented:
1. What's the error message?
2. Have you tried other field terminators, like a vertical bar '|'?
0
 
Scott PletcherSenior DBACommented:
You can use semi-colon, so there must be some other issue.

Verify the contents of the file match the table exactly.

And please post the specific error, that would help a lot.
0
 
CochiseCountyAuthor Commented:
You are right, I type the table's name wrong. It works now. Thanks
0
 
amit1978Commented:
U have to update registry to use semicolan insted of ','

If still having a problem please let us know
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now