Skip to main content

Use AzCopy

Determines if the generated files must be uploaded using AzCopy as part of the SSIS Packages. Disable if the solution uses an alternative file management process.

When enabled, the source-to-file load packages include the AzCopy steps that upload the exported files to the Azure staging storage account. The steps are not generated for Snowflake data warehouse targets, which stage files through their own load process.

When to Change This Setting​

Keep the default Y when BimlFlex should move the exported files to Azure storage as part of the load. Disable it when an external process (for example a separate orchestration or file transfer tool) is responsible for moving the files.

SettingInteraction
AzCopyPathWhere the AzCopy executable is found
AzCopyVersionWhich AzCopy command line is generated
AzCopyUseSasTokenHow the upload authenticates to the storage account

Notes​

  • This setting is part of the AzCopy settings category.
  • The default value for this setting is Y.