This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
See Create tables, bulk import, and query data - Learn. It describes use of bcp to import the data. When I do I get:
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid character value for cast specification
for each of the 5 records. I think I followed the instructions.
My mytable.fmt file is:
14.0
2
1 SQLCHAR 0 12 "," 2 MyColumn1 ""
2 SQLCHAR 0 50 "\r\n" 1 MyColumn2 SQL_Latin1_General_CP1_CI_AS
My mydata.csv is as provided in the tutorial. I was a little confused because the tutorial says bash but I assume I should use a normal Windows command prompt. So I created a cmd file with the following:
bcp Tutorials.dbo.mytable in mydata.csv -f mytable.fmt -S samstutorialserver.database.windows.net -U Sam -P password -F 2
Did I miss seeing something in the tutorial or is the tutorial unclear or something else? What is causing the error?
Probably you should not change the order of columns if it is not needed. Try this .fmt file:
14.0
2
1 SQLCHAR 0 12 "," 1 MyColumn1 ""
2 SQLCHAR 0 50 "\r\n" 2 MyColumn2 SQL_Latin1_General_CP1_CI_AS
Thank you. I should have figured that out. The tutorial says you should edit the format file and change the field numbers. I changed the field numbers only because the tutorial says to.
So this will be here in case someone else is mislead by the tutorial.
Maybe you can report the unclarity using the “reporting an issue” link, “Learning content quality”, etc.
Actually I did that before posting here. I do not know if they will provide an answer; obviously this was faster. There are other issues I intend to report, such as the use of bash instead of command prompt; there should at least be an explanation. Also they should say that bcp needs to be downloaded (and installed) if that is true; perhaps I did not need to but I did. Also they state that the field names are different, implying we need to specify the difference but we do not need to.