SSIS Components for CSV

Build 25.0.9539

TestConnectionBehavior

Specifies the behavior of the test connection operation.

Possible Values

LIST_AND_READ_FILES, READ_FILE, LIST_FILES, NO_OPERATION, AUTHENTICATE, LIST_OR_READ_FILES

Data Type

string

Default Value

"LIST_OR_READ_FILES"

Remarks

Change how the component responds to a test connection operation based on the integration scenario.

  • LIST_AND_READ_FILES: Deprecated, renamed to LIST_OR_READ_FILES. List or read files from the configured storage source until at least one is parsed. Fail if none of the files can be parsed. Note: this mode will not read files in sub-directories.
  • READ_FILE: Read the file provided in the URI. Succeed if the file can be read and parsed. Use this mode if the URI points to a file, not a directory.
  • LIST_FILES: List files from the provided URI.
  • NO_OPERATION: Does not perform any operation on the storage source.
  • AUTHENTICATE: Tests if the credentials are valid by making a metadata or list call.
  • LIST_OR_READ_FILES: List or read files from the configured storage source until at least one is parsed. Fail if none of the files can be parsed. Note: this mode will not read files in sub-directories.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539