Note: The samples in this section use Coastal Risk (Distance to Coast) as an example. All products are uploaded using the same steps. Related scripts for each product are found in the Prerequisites section.
- Download the product delivery file.
- Extract the delivery file to find the text data file.
- Create the table structure in the database using the Create Table script. Be sure to change the table name in the template to the name of the dataset you are loading. If, for example, you are loading the data for Coastal Risk (Distance to Coast), the table should be named dist_to_coast.
- If a new format (FMT) file needs to be created, follow the steps found in https://msdn.microsoft.com/en-us/library/ms191516.aspx.
- 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 passed, 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 risk.dbo format nul -c -f C:\Distance_to_Coast\asmt.FMT -t "|" -S
-T
Note: Once the format file has been generated, \r needs to be removed from the file in order for data to load successfully.