Previous Topic: Use Skip Logic in a Sequential Transfer JobNext Topic: dtscli Command—Add Parcel Filters


dtscli Command—Apply Filters

The dtscli command can be used to send filtered transfers. DTS agents can apply filters when a file is being transferred. Filters transform data in some way, such as encryption and decryption, compression and decompression.

Basic categories of filters:

File Filters (f_filters)

Process the data being transferred one file at a time. File filters are applied to the entire file before it is transferred.

Parcel Filters (p_filters)

Process the data being transferred one parcel at a time. (A parcel is a smaller unit of data within the file.) Parcel filters are applied as the file is being transferred.

Filters usually work in pairs. The write filter must reverse an action performed by the read filter. Filters are applied in the following order:

  1. File read filters
  2. Parcel read filters
  3. Parcel write filters
  4. File write filters

Read filters of the same type (file or parcel) are applied in the same order that they are specified on the command line. Write filters of the same type are applied in the reverse order that they are specified on the command line.

Typically, specify filter parameters for agent-to-agent transfers only, not for managed transfers. The only exception is any encryption filter. For example, Data Transport Service supplies the PLAIN file and parcel encryption filters, each of which requires the ENDEC_KEY parameter. For both managed transfers and agent-to-agent transfers, specify the ENDEC_KEY when you use the PLAIN encryption filters. For all other filters that require parameters, managed transfers automatically take the values from Transfer Object Server.

More information:

Agent-to-Agent Transfers

dtscli -transfer Parameter Group—Perform Managed Transfers

dtscli -agent Parameter Group—Perform Agent-to-Agent Transfers

Predefined Filters