1. download secure-roll csv file
https://arc-property-information-open-data-sbcounty.hub.arcgis.com/
username: covgis1
password: xxxxxxxx
2. SQL server import secure-roll into SQL server table secured-roll
3. modify column name as old back up
4. import failed with error, column id 26 length is not length enough to hold the value in .csv file.
5. open csv file, warning, it use '~' as seperator, instead of commna,
6. change file type from csv to text
7. open blank excel, open text file
8. error message says column 26 cause problem, but which column is column 26
https://stackoverflow.com/questions/10442686/received-an-invalid-column-length-from-the-bcp-client-for-colid-6
9. I just use varchar(max) for all column it works.
10. success