Procedure - insurance_premium_tax - Latest

Geoenrichment Risk - Insurance Premium Tax Getting Started Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Boundaries > Risk Boundaries
Product
Insurance Premium Tax
Version
Latest
Language
English
Product name
Geoenrichment Risk Insurance Premium Tax
Title
Geoenrichment Risk - Insurance Premium Tax Getting Started Guide
Copyright
2023
First publish date
2018
ft:lastEdition
2023-07-31
ft:lastPublication
2023-07-31T11:39:57.587584
  1. Download the product delivery file.
  2. Extract the delivery file to find the text data file.
  3. Create the table structure in the database using the Create Table script. Be sure to change the table name in the template to the dataset you are loading. If, for example, you are loading a dataset for Insurance Premium Tax, the table should be named insurance_premium_tax.
  4. 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.
  5. 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 pipe character as a delimiter.

    Example:
    bcp risk.dbo format nul -c -f C:\Insurance_Premium_Tax\insurance_premium_tax.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.