SSIS Components for Google Sheets

Build 20.0.7587

Type Detection Scheme

Determines how to determine the data types of columns.

Data Type


Default Value



NoneSetting TypeDetectionScheme to None will return all columns as the string type. Note: Even when set to None, the column names will still be scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587