Element Details: Sql+Server+Custom+Format+File
 Back


Available in: Logi Info Source code name: SqlServerCustomFormatFile

Normally you will not need to use this element since ETL automatically generates a Microsoft format file based on the information provided by the LoadDbTable.Insert element.

Use this element to replace the automatically generated file with your custom format file. The custom format file provided will be passed to Microsoft's Bulk Copy Program (BCP) for processing.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CustomFormatFileText
UserDefined
(Required) The text of the custom SQL Server format file to use. In addition to the standard Logi tokens, the following custom tokens are also available. The values for these tokens are automatically defined based on the attribute values of your LoadDbTable.Insert element. @Etl.BulkDataFile~ = Full name of the dat file to import. @Etl.BulkTableName~ = Destination table name. @Etl.BulkFieldDelimiter~ = Field delimiter. @Etl.BulkTextQualifier~ = Text qualifier. @Etl.BulkRowDelimiter~ = Row delimiter.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Load DB Table.Insert


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top