SSIS Components for Microsoft Excel Online

Build 25.0.9434

SeparatorCharacter

Specifies the character used to separate the workbook name and worksheet name in the generated table name.

Data Type

string

Default Value

"_"

Remarks

The separator character is inserted between the workbook and worksheet names when forming the table name.

For example:

  • If set to "_": MyWorkbook_Sheet1
  • If set to "-": MyWorkbook-Sheet1
  • If set to "#": MyWorkbook#Sheet1

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