Loading Serviceability Extended Attributes Data - serviceability_extended_attributes - Latest

Serviceability Extended Attributes Getting Started Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > World Addresses
Product
Address Fabric™ Data > Serviceability Extended Attributes
Version
Latest
ft:locale
en-US
Product name
Serviceability Extended Attributes
ft:title
Serviceability Extended Attributes Getting Started Guide
Copyright
2023
First publish date
2021
ft:lastEdition
2025-02-05
ft:lastPublication
2025-02-05T08:56:26.227000
  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.