Skip to main content

Archive Stage

Determines if the staged Blob Storage files are moved to the defined archive container, once processing is completed. This will use AzCopy v.10 commands, so requires AzCopy v.10 and SAS Tokens for access.

In the generated SSIS staging flow, enabling this adds AzCopy steps that create the archive container if needed, copy the object's staged files from the stage container to the archive container, and remove them from the stage container. The steps are only generated when the configured AzCopy Version is 10 or later, and they authenticate with the stage and archive SAS tokens.

When to Change This Setting​

Enable this to keep a per-load history of the staged files in the archive container instead of leaving them in the stage container. It requires AzCopy v10 and SAS tokens for both the stage and archive storage accounts.

SettingInteraction
AzCopy VersionMust be 10 or later for the archive-stage steps to be generated
Stage ContainerThe container the staged files are moved from
Archive ContainerThe container the staged files are moved to
Stage SAS TokenAuthenticates the copy from the stage container
Archive SAS TokenAuthenticates the copy to the archive container

Notes​

  • This setting is part of the Azure settings category.
  • The default value for this setting is N.