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

 

by

Please log in or register