Loading Property Historical Sales Change Log Data - property_historical_sales - Latest

Property Historical Sales Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > Property Features
Product
Property Historical Sales
Version
Latest
ft:locale
en-US
Product name
Property Historical Sales
ft:title
Property Historical Sales Getting Started Guide
Copyright
2023
First publish date
2020
ft:lastEdition
2023-07-31
ft:lastPublication
2023-07-31T10:42:31.621000
  1. Download the product delivery file.
  2. Extract the delivery file to find the data text file.
  3. Download the Create Table script.
  4. Open the Create Table script in a text editor and confirm that the table name is set to prop_hist_sales_change_log
  5. If a new format (FMT) file needs to be created, please follow the steps found in https://msdn.microsoft.com/en-us/library/ms191516.aspx.
  6. Issue the following command:
    bcp <database_name>.dbo.<table_name> format null -c -f <path>\format_file_name.fmt -t "|" -S -T
    Syntax:

    -T: Specifies that the bcp utility connects to SQL Server with a trusted connection using integrated security. If -T is not specified, the -U and -P parameters for username and password must be passed in order to log in.

    -t "|": Specifies that the format file will be generated using the pipe character as a delimiter.

    Example: 
    “bcp PAD.dbo.prop_hist_sales format nul -c -f C:\Property_Historical_Sales_202009\
change_hist_sales.FMT -t "|" –S –T ”
Note: Once the format file has been generated, \r needs to be removed from the file in order to load data successfully.