SSIS Components for Smartsheet

Build 23.0.8839

Data Type Mapping

Data Type Mappings

The component maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.

Smartsheet CData Schema
Auto-Number int
Checkbox bool
Contact list string
Created (Date) datetime
Created By string
Date date
Dropdown List string
Modified (Date) datetime
Modified By string
Symbols (Flag/Star) bool
Symbols (Dropdowns) string
Text/Number (Text) string
Text/Number (Whole Number) int (<2,147,483,647) or long (>2,147,483,647)
Text/Number (Decimal) float

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839