Account
Skip to main content

Apply Extract Conversion In Data Flow

Determines if SSIS extracts-to-file apply data conversion for target files in the SSIS Data Flow instead of in the source select statement.

When disabled, the source select statement of an SSIS extract-to-file package applies the extract conversion expressions to string, XML and date columns. When enabled, the source select statement reads these columns without conversion. String, date and XML columns that have no SQL source expression or data flow expression are selected under an alias with the CNV_ prefix, except for Salesforce sources.

The SSIS Data Flow then converts the columns before the file is written. A Derived Column transformation converts string and date columns, replacing line feed, carriage return and pipe characters in string values and writing date values as text. A Script Component replaces the same characters in large columns: Unicode strings longer than 4000 characters, non-Unicode strings longer than 8000 characters, strings of maximum length and XML columns.

Salesforce sources always convert in the SSIS Data Flow, whatever the value of this setting.

When to Change This Setting​

Keep the default N to convert the columns in the source select statement. Enable it when the conversion should run in the SSIS Data Flow instead of in the source select statement.

Notes​

  • This setting is part of the Staging settings category.
  • The default value for this setting is N.