The CData SSIS Components for Microsoft Excel is designed for streaming Microsoft Excel only.

This streamed file content does not include all of the metadata associated with remotely stored Microsoft Excel files, such as file and folder name.

If access to both the file metadata and the actual file content is needed, then the CData SSIS Components for Microsoft Excel must be used in tandem with the associated file system driver(s) for the service the Microsoft Excel files are remotely stored in.

The following file system drivers are available:

• AmazonS3
• Box
• Dropbox
• FTP
• GoogleCloudStorage
• IBLCloudObjectStorage
• OneDrive
• SFTP

See the relevant CData file system driver's documentation for a configuration guide for connecting to stored Microsoft Excel file metadata.