Table of Contents

Search

  1. Preface
  2. Informatica Managed File Transfer Welcome Overview
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Password Protect Excel Task

Password Protect Excel Task

The Password Protect Excel task encrypts Microsoft Excel .xlsx documents.
Field
Definition
Basic Tab
Label
Specify a label for this task.
Source File
Specify the path and file name of a single file to be password protected.
Source Files Variable
Specify the name of a variable of type File List which contains the files to password protect. For example, ${variableName}.
Destination File
Specify the path and file name where the file will be created with password protection.
Destination Directory
Specify the directory to which the specified source files should be placed after they are password protected. You must specify this attribute if you are password protecting multiple files using one or more File Set elements, or a Source Files Variable.
Password
Specify the password to protect the Excel file.
Is Password Encrypted?
Specify whether or not the password is in encrypted form.
Default Value: false
When File Exists
Specify the action to take when the destination file already exists. The default value is 'rename' which changes the destination file name to a new name so the existing file remains untouched.
Default Value: rename
Advanced Tab
Encryption Algorithm
Specify the encryption algorithm.
Default Value: AES128
Hash Algorithm
Specify the hash algorithm to use.
Default Value: SHA1
Output Variables Tab
Destination Files Variable
If desired, specify the name of a variable which will contain the file(s) in the destination location. The variable will be of type File List and may be used in subsequent tasks that accept a File List input variable. The variable will be created if it does not exist.
Control Tab
Version
The version of this task.
Log Level
Specify the level of logging to use while executing this task. Valid options are - silent, normal, verbose and debug.
Default Value: Inherited from parent Module
Execute Only If
Specify a condition that must be satisfied before this task can be executed. This task will be skipped if the specified condition is not met.
Disabled
Whether or not this task is disabled.
Default Value: false
On Error Tab
On Error
Specify the action to take when this task errors out. Valid options are - abort, continue, call:[module] and setVariable:[name]=[value]. For call:[module] replace [module] with the name of the module in the project (e.g. call:ErrorModule). For setVariable:[name]=[value] replace [name] with a variable name and [value] with the variable value (e.g. setVariable:error=true).
Default Value: Inherited from parent Module

0 COMMENTS

We’d like to hear from you!