SSIS Components for Microsoft Excel

Build 24.0.8963

Connection

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


PropertyDescription
ConnectionTypeSpecifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retreived.
URIThe Uniform Resource Identifier (URI) for the Excel resource location.
DefineTablesMap Excel ranges to table names.
HeaderIndicates whether the first row should be used as a column header.
OrientationIndicates whether the data in Excel is laid out horizontally or vertically.
ExcelFileThe location of an Excel file.
BufferChangesIndicates whether to hold changes to the data in memory until the connection is closed.
RegionThe hosting region for your S3-like Web Services.
ProjectIdThe Id of the project where your Google Cloud Storage instance resides.
OracleNamespaceThe Oracle Cloud Object Storage namespace to use.
StorageBaseURLThe URL of a cloud storage service provider.
UseVirtualHostingIf true (default), buckets will be referenced in the request using the hosted-style request: http://yourbucket.s3.amazonaws.com/yourobject. If set to false, the bean will use the path-style request: http://s3.amazonaws.com/yourbucket/yourobject. Note that this property will be set to false, in case of an S3 based custom service when the CustomURL is specified.
UseLakeFormationWhen this property is set to true, AWSLakeFormation service will be used to retrieve temporary credentials, which enforce access policies against the user based on the configured IAM role. The service can be used when authenticating through OKTA, ADFS, AzureAD, PingFederate, while providing a SAML assertion.

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