- Download the Field Value Key data 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 to asmt_field_value_key.
- If a new format (FMT) file needs to be created, follow the steps 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 pipe character as a delimiter.
Example:bcp PAD.dbo.asmt_field_value_key format nul -c -f E:\PAD\asmt_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.