Why BCP cannot import any record into the tables with SQL Azure?
- Make sure the Server connection string does not contain a semi-column (;)
at the end, like this <ServerURL>jdbc:sqlserver://SERVER:1433;database=DATABASE;</ServerURL>
- Try to use a password without too many special characters, such password will make BCP fail <Login User="user_login" Password="-dP.\w9VBygI"/>
- Avoid to have a database name starting with a digit. Instead of “1WorldSync“ for example, preferably use “OneWorldSync“
