Loading US Address Fabric™ Data Change Log - address_fabric_1 - Latest

United States Address Fabric™ Data

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 US_AddressFabric_ChangeLog

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 AF.dbo.us_address_fabric format nul -c -f C:\
   United_States_Address_Fabric_ChangeLog_CA\us_address_fabric_changelog.FMT -t "    " –S –T