OutputKey | Setting this to True will cause 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 will set the SSIS data type to DT_NTEXT allowing for arbitrary length fields. |
ConvertDateTimeToGMT | Determines whether to convert date-time values to GMT, instead of the local time of the machine. |
RecordToFile=filename | Records the underlying socket data transfer to the specified file. |