Share via

in exported data out re-created the table and now want to import it back but getting the below error

Anonymous
2024-05-22T06:54:43+00:00

bcp "SELECT * from dp_history21052024 WHERE CONVERT(DATE,effective_dt,103) >'29-Feb-2024'" queryout "D:\Data\Data.csv" -S ORBITLITEDB-SVR -d OrbitLiteLive -U sa -P Tested123 -c -t, -r\n

and then the below for import

bcp OrbitLiteLive.dbo.dp_history in "D:\Data\Data.csv" -S ORBITLITEDB-SVR -U sa -P Tested123 -c -t, -r\n -E -k -q -T -k -F 2 -e -o "D:\Data\error.txt"

Starting copy...
1000 rows sent to SQL Server. Total sent: 1000
1000 rows sent to SQL Server. Total sent: 2000
1000 rows sent to SQL Server. Total sent: 3000
1000 rows sent to SQL Server. Total sent: 4000
1000 rows sent to SQL Server. Total sent: 5000
1000 rows sent to SQL Server. Total sent: 6000
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Invalid date format

6003 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 266 Average : (22567.67 rows per sec.)

Windows Server Devices and deployment

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-22T07:06:55+00:00

    Hello Godfrey Mugisa,

    thank you for posting on the Microsoft Community Forums.

    Based on the description, I understand that your issue is related to SQL Server.

    Since there are no engineers dedicated to SQL Server in this forum. In order to be able to deal with your questions quickly and efficiently, I recommend that you repost your questions in the Q&A forum, where there will be a dedicated engineer to provide you with a professional and effective response.

    Here is a link to the Q&A forum: https://learn.microsoft.com/en-us/answers/questions/

    Have a nice day.

    Best regards,

    Lei

    0 comments