Other
Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
Data Type
string
Default Value
""
Remarks
This property allows advanced users to configure hidden properties for specialized situations, with the advice of our Support team. These settings are not required for normal use cases but can address unique requirements or provide additional functionality. To define multiple properties, use a semicolon-separated list.
Note: It is strongly recommended to set these properties only when advised by the Support team to address specific scenarios or issues.
Integration and Formatting
| Property | Description |
| OutputKey | Setting this to True causes the error output to include new output columns containing the primary key values for newly inserted records. |
| DefaultColumnSize | Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000. Setting this value higher than 4000 sets the SSIS data type to DT_NTEXT allowing for arbitrary length fields. |
| ConvertDateTimeToGMT=True | Converts date-time values to GMT, instead of the local time of the machine. The default value is False (use local time). |
| RecordToFile=filename | Records the underlying socket data transfer to the specified file. |