SSIS Components for Smartsheet

Build 25.0.9434

UseFullFilePathsAsTableNames

Specifies whether table and view names corresponding to sheets and reports should include the full file path or only the file name.

Data Type

bool

Default Value

false

Remarks

This property controls the naming convention for tables and views exposed by the driver. If set to true, table and view names include the full file path, providing greater context for each dataset. For example, a table representing a sheet might be named SalesSheets_Agents_MonthlyReports_Sheet_JuneSheet. If set to false, only the file name is used in the table and view names. For example, Sheet_JuneSheet.

This property is useful when working with datasets that may contain files with similar names in different directories. Including the full file path helps to distinguish between files and provides additional clarity. However, for simpler datasets or use cases where shorter table names are preferred, setting this property to false can improve readability and simplify queries.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434