Raw File Custom Properties

 

Applies To: SQL Server 2016

Source Custom Properties

The Raw File source has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the Raw File source. All properties are read/write.

Property nameData TypeDescription
AccessModeInteger (enumeration)The mode used to access the raw data. The possible values are File name (0) and File name from variable (1). The default value is File name (0).
FileNameStringThe path and file name of the source file.

The output and the output columns of the Raw File source have no custom properties.

For more information, see Raw File Source.

Destination Custom Properties

The Raw File destination has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the Raw File destination. All properties are read/write.

Property nameData TypeDescription
AccessModeInteger (enumeration)A value that specifies whether the FileName property contains a file name, or the name of a variable that contains a file name. The options are File name (0) and File name from variable (1).
FileNameStringThe name of the file to which the Raw File destination writes.
WriteOptionInteger (enumeration)A value that specifies whether the Raw File destination deletes an existing file that has the same name. The options are Create Always (0), Create Once (1), Truncate and Append (3), and Append (2). The default value of this property is Create Always (0).
System_CAPS_ICON_note.jpg Note


An append operation requires the metadata of the appended data to match the metadata of the data already present in the file.

The input and the input columns of the Raw File destination have no custom properties.

For more information, see Raw File Destination.

Common Properties

Community Additions

ADD
Show: