Loading Serviceability Extended Attributes Data - serviceability_extended_attributes - Main

Serviceability Extended Attributes Getting Started Guide

Product
Address Fabric™ Data > Serviceability Extended Attributes
Version
Main
Language
English
Portfolio
Enrich
Product family
world_addresses
Product name
Serviceability Extended Attributes
Title
Serviceability Extended Attributes Getting Started Guide
Copyright
2023
First publish date
2022
  1. Download the product delivery file

  2. Extract the delivery file and 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 serviceability_extended_attributes

  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 nul -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 tab delimiter.

    Example:
    bcp serviceability_extended_attributes format nul -c -f C:\
    serviceability_extended_attributes\serviceability_extended_attributes.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.