- Download the text file US Field Value Key for US Address Fabric™ Data or CAN Field Value Key for Canada Address Fabric™ Data.
- Download the US Create Table script for US Address Fabric™ Data or CAN Create Table script for Canada Address Fabric™ Data.
-
Open the Create Table script in a text editor and confirm that the table name is set to US_Field_Value_Key.
- 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.
- Issue the following
command:
Syntax:bcp <database_name>.dbo.<table_name> format nul -c -f <path>\format_file_name.fmt -t " " -S -T-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 AF.dbo.field_value_key format nul -c -f C:\ us_field_value_key\us_field_value_key.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.