SSIS Components for Microsoft Access

Build 25.0.9434

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
CreateNewDatabaseSpecifies what format shoud be used by a new database file created when the file specified by connection property DataSource does not exist.
DeleteDownloadedFilesWhen set to true, the provider deletes the MS Access database file downloaded from cloud sources upon closing the connection.
ExcludeFilesComma-separated list of file extensions to exclude from the set of the files modeled as tables.
ExcludeStorageClassesA comma seperated list of storage classes to ignore.
FolderIdThe ID of a folder in Google Drive. If set, the resource location specified by the URI is relative to the Folder ID for all operations.
IncludeDropboxTeamResourcesIndicates if you want to include Dropbox team files and folders.
IncludeFilesComma-separated list of file extensions to include into the set of the files modeled as tables.
IncludeItemsFromAllDrivesWhether Google Drive shared drive items should be included in results. If not present or set to false, then shared drive items are not returned.
IncludeMSysTablesSet this property to the true value to allow querying from the system tables.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
ReadonlyToggles read-only access to Microsoft Access from the provider.
RTKSpecifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key.
TemporaryLocalFolderThe path, or URI, to the folder that is used to temporarily download the MS Access database file.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UseDatabaseNameAsSchemaSet this property to the true value to expose database file name without extension as schema name by meta-data.

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