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

Example 2: Password Protect a Set of Excel Files

Example 2: Password Protect a Set of Excel Files

Follow the steps below to password protect a set of Excel files.
  1. From within the Project Designer page, expand the File System folder in the Component Library, and then drag the Create File List task to the Project Outline.
  2. On the Basic tab of the Create File List task, specify values for the following attributes:
    File List Variable
    The name of a variable that will contain the list of files being created. If this variable exists it will be overwritten, otherwise it will be created.
  3. Click the
    Add
    button.  This displays a sub-menu of “Action” items that can be performed.
  4. Choose the
    Add a File Set
    option from the sub-menu.
  5. On the Basic tab of the File Set option, specify values for the following attributes:
    Base Directory - The starting directory for this File Set. If no filters are defined, all files in this directory will be included.
  6. From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Password Protect Excel task to the Project Outline.
  7. On the Basic tab of the Password Protect Excel task, specify values for the following attributes:
    Source Files Variable
    Specify the name of a variable of type File List which contains the files to password protect. For example, ${fileList}.
    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 files.

0 COMMENTS

We’d like to hear from you!